refer to the cell as it is empty...

  • Thread starter Thread starter Miri
  • Start date Start date
M

Miri

when i use a formula like: if(A1=2,"ok","") in cell B1.
Is there a way to write the formula in other way that in case A1<>2 my cell
will be empty?
i'll explain what i mean...
before i added the formula to cell B1 it was empty(not in use). other cells
that refers to B1 saw him as a zero value.
after i used my formula it is not a zero any more... it is "".
but i do not want to change the formula to be if(A1=2,"ok",0) since i have
conditional format if the value is 0.
i need the formula if(A1=2,"ok",????) to represent a clear cell... how
should i do that?

thanks
Miri Tz.
 
You should keep your equation in B1 as you have written it. The formulas in
other cells can be made to understand that B1 contains "" and not 0.
 
Once you put the formula in the cell, the cell won't be empty.

You could modify the other formulas, though:

=n(b1)+1234

(for instance)
 
Back
Top