Try...
=IF(I19=0,"NA",IF(I19=45, "y", "n"))
HTH
"Bert via OfficeKB.com" wrote:
I have tried to enter this formula and keep getting an error message.
if I19 =45,"y","n" or if I19 =0 then "NA".
No Matter how I enter this formula, I get an error message. Please help.
Thank you.
--
Message posted via http://www.officekb.com