Blank cell fromula
Not clear what result the formula should produce if your 2 conditions are
*not* met. Anyway here is an example:
=IF(OR(A1="Y",ISBLANK(A1)),0,"NotYorBlank")
Joerg Mochikun
"Kay" wrote in message
...
Is it possible to have a formula for two arguments example
I already have a fromula =if A1="Y",0
I want the formula to be like =if A1="Y" or blankcell,0 (I want if the
cell
is left blank aswell it will be equal to 0.
--
KK
|