=IF(ISBLANK(D3),"",IF(D3=0,"N","Y"))

Dave
--
Brevity is the soul of wit.


"cmccurdy23" wrote:

This should be simple, but I can't quite get it.


If D3 is "" then"" otherwise if D3 is "0" then "N" otherwise "Y"

in other words, if d3 is greater than "1" then "Y" if it is equal to "0"
then "N" if d3 has no data then " "

I've tried nested if's and isblank. My result: if the cell is blank I get
blank, if the cell is 0 I get Y if has any other value I get "Y"

Please help, this should be so easy!