-------- Original Message -------- From: mxk [mailto:mxkeat...@comcast.net] Sent: Saturday, September 25, 2021, 16:02 UTC To: users@global.libreoffice.org Subject: [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 If you don't want to use cell references, how would you inform Calc which one of the thousands of cells in a sheet was the one holding the value you wanted it to use in your calculations? If you actually do see A1/10 in cell A2, this suggests that cell A1 is formatted as text not a numeric value. In which case =VALUE(A1)/10 does work. You will find some excellent Calc User Guides here: https://tinyurl.com/aa4mrlt LibreOffice version 5.2.7.2 is quite old and I would recommend updating to at least version 7.1.6 from: https://www.libreoffice.org/download/download/ Dave -- To unsubscribe e-mail to: users+unsubscr...@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