I have not been able to find a function which will convert a formula in a spreadsheet to its absolute value. Is there one?
My use of this is to "freeze" 2014 financial calculations as history in the 2014 column, allowing the formula (now working in the new 2015 column) to produce current results. For example, if I type =ABS(N511/O511) -- where the value of N511=100 and the value of O511=50 -- I want to see only the number 2 in the cell. Is there a way to accomplish this? Thanks for any insights. Maggie
