problem with formula
 

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

problem with formula
 

=IF(I19=0,"NA",IF(I19=45,"y","n"))

Troy

"Bert via OfficeKB.com" wrote in message
...
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

problem with formula
 

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