Does this do what you want
=IF(D3="","",IF(D3=0,"N","Y"))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"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!