I didn't actually use quotes around numbers in my formala, but thanks. I was
just trying to explain it well, guess I made it a little confusing. The
first formula you provided did not work, but Dave F has solved the problem.

" wrote:

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