At 14:37 16/01/2015 -0700, Maggie Butler wrote:
I have not been able to find a function which will convert a formula
in a spreadsheet to its absolute value. Is there one?
It cannot be a function, of course, as that would merely mean that
you had that function in the cell instead of the one you already have!
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.
You *will* see only the number 2 in the cell. But yes: you mean that
you want the cell to contain the simple number 2 rather than a
formula that evaluates to 2.
Is there a way to accomplish this?
Yes: Paste Special is your friend.
o Copy the cell or range.
o Paste the result back over the original (or wherever you prefer),
but using Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste.
o In the Paste Special dialogue, remove the tick from "Paste all" if
necessary, and ensure that Formulae is *not* ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
