[libreoffice-users] extracting cell values

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: users+unsubscribe@global.libreoffice.org
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