View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default 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