help please

[Brown]

you guys have gotten me through some tough times with this new version of Excel in the last few days, and I found something I did not think of at the time. I have the following formula in a column that is totaling something for me. My problem is everything below 69 (<69) gets counted as "DNM", but if the cell is blank I need the calculating cell to stay blank.
=IF(D36>89,"EXC",IF(D36<70,"DNM","MET"))
I am placing grades in one column and the ajoining column ranks the grade. Now I need to rewrite the formula to leave a blank if the cell is blank.
Thanks for your help.
Brown

 

[Marcelo Branco]

Maybe

=IF(D36="","",IF(D36>89,"EXC",IF(D36<70,"DNM","MET")))

M.

 

[Brown]

will try it right now thanks for the quick response
brown

 

[Brown]

That did it!
I was trying to do it, but putting the extra if at the back of the formula.
Thanks
Brown

 

[Marcelo Branco]

That did it!
I was trying to do it, but putting the extra if at the back of the formula.
Thanks
Brown

You are welcome and tks for the feedback

M.