"cmccurdy23" wrote:
If D3 is "" then"" otherwise if D3 is "0" then "N" otherwise "Y"

=if(D3="", "", if(D3=0, "N", "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 " "

That is potentially different logic, depending on assumptions about what is
in D3.

=if(D31, "Y", if(D3=0, "N", ""))

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"

Perhaps due to your bad habit of putting quotes around numbers, as you did
not in this posting.