Dave F.
congrats and more power..
regards
--
*****
birds of the same feather flock together..



"Dave F" wrote:

No idea.
--
Brevity is the soul of wit.


"Allllen" wrote:

now you have a silver medal
what is going on?
--
Allllen


"Dave F" wrote:

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