hi
=if(or(A1="Y",A1=""),0,"?")

the if formula reads like this
if (condition, result if true, result if false)
if you don't have a result if false part and the conditions is false, excel
will diplay the word false. you don't have a result if false part in your
example so i just put a question mark. the above syntax should work.

Regards
FSt1

"Kay" wrote:

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