Walter Hildebrandt wrote:
an additional IF is needed in the spreadsheet. (I think this will be the
last IF needed request)
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.
My original formula still stands:
=IF(A1;A1-3;"")
1 2 3
if 1 (A1) is true (has any value) then put 2 (A1-3) in cell B1, or else
put Null (Nothing) in 3
Whatever value you need added or subtracted to A1, substitute that value
for the second condition in the above formula;
ie; to make the value in B1 equal to A1 plus 6
=IF(A1;A1+6;"")
FOR A1 minus 77
=IF(A1;A1-77;"")
You SHOULD be able to figure out any further conditions.
--
Gene Y.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
