3 columns

[Brown]

I am trying to take a grade (col d) and have it returned as EXC , MET , DNM in the next column or three columns (e,f,g)
I can get the EXC to show up using =if(d2>89,"EXC"). I can also get the last column to show DNM using =if(d2<70,"DNM"). My problem is that I do not know how to get the MET to show in the third column since it should only appear if the score is between 69&89.
Can some one please help me with this?
Thanks
Brown

 

[T. Valko]

I am trying to take a grade (col d) and have it returned as EXC , MET , DNM in the next column or three columns (e,f,g)
I can get the EXC to show up using =if(d2>89,"EXC"). I can also get the last column to show DNM using =if(d2<70,"DNM"). My problem is that I do not know how to get the MET to show in the third column since it should only appear if the score is between 69&89.
Can some one please help me with this?
Thanks
Brown

Maybe this...

=IF(AND(D2>=70,D2<=89),"MET","")

 

[JoeMo]

I am trying to take a grade (col d) and have it returned as EXC , MET , DNM in the next column or three columns (e,f,g)
I can get the EXC to show up using =if(d2>89,"EXC"). I can also get the last column to show DNM using =if(d2<70,"DNM"). My problem is that I do not know how to get the MET to show in the third column since it should only appear if the score is between 69&89.
Can some one please help me with this?
Thanks
Brown

For a single column solution:

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

 

[Brown]

Thanks you so very much for the quick answer. I will try it in the morning when I get to work.
Brown