Users Ahoy:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical value
from a cell, and use that instead of the cell reference in further
calculations?
Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can I
program it, (if at all)?
If I put =A1/10 into A2, A2 will contain A1/10, not 16.7,even though it
will display as 16.7.
I want to get away from cell references and use the contained values. Can I?
I thought that =VALUE(A1)/10 might work, but the result continues to use
the cell reference, not the contained value.
Miss K
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
