At 15:41 08/03/2009 -0600, Walter Hildebrandt wrote:
an additional IF is needed in the spreadsheet. (I think this will
be the last IF needed request)
Phew!
If A1 is empty then B1 should be empty
If A1 has any number in it, that number in A1 is reduced by 3. If
there is 0 in A1 then B1 would be -3. If there is a 4 in A1 then B1
would be 1. If there is a 3 in A1 then B1 would be 0.
This is called subtraction. Try:
=IF(ISBLANK(A1);"";A1-3)
or:
=IF(ISNUMBER(A1);A1-3;"")
At 22:56 08/03/2009 +0100, Franz Wein wrote:
write in B1: *= if(A1="";A1;A1-3)*
Actually, this doesn't work: if A is empty it gives zero for B, not
the empty cell required. You could change this slightly to:
=IF(A1="";"";A1-3)
At 18:35 08/03/2009 -0400, Gene Young wrote:
My original formula still stands:
=IF(A1;A1-3;"")
This also doesn't work: it fails to distinguish zero and empty in A,
so zero in A gives an empty cell for B, not the -3 required.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
