Another question, This has me stumped. I have the following formula.=SUM(B2+128)/256
I am normalizing values to 0.0 - 1.0. The addition of 126 is to offset the negative range of possible values and make all values positive. However if B2 (as an example) is empty I get 0.5 (128/256) in the destination cell
how can I make it return nothing if B2 is empty?
You need to write the condition in the formula, not on this site
.
Try =IF(B2="";"";=SUM(B2+128)/256)
.
You could also use ISBLANK(B2) to tet contents of B2
https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISBLANK
Thanks,but this gives me an Error:510…I look at the link
Sorry, quick copy/paste on my phone.
But I guess it is obvious: I left the original leading = in (before SUM), so try:
=IF(B2="";"";SUM(B2+128)/256)
Bingo!!! Thanks
declare the valid value range by testing the possible cases:
testing valid value range_083650.ods (34.9 KB)