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.
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.