Returning text after a specific value with restrictions

[ddennis]

Dear all:

I am currently using this code to return specific text when a value is computed:

=IF(G5>=3.8,"SUMMA CUM LAUDE",IF(G5>=3.5,"MAGNA CUM LAUDE", IF(G5<=3.2,"NONE",IF(G5>=3.2,"CUM LAUDE",""))))

So far, It works well. However; in another column I2, which is named "Division", the cells is populated with "Graduate" and "Undergraduate".

I would like to apply the above statement to the Undergraduates ONLY and return the appropriate message.

Many thanks in advance.

Regards,

Dion

 

[onlyadrafter]

Hello

I think

=IF(I5="Undergraduate",IF(G5>=3.8,"SUMMA CUM LAUDE",IF(G5>=3.5,"MAGNA CUM LAUDE",IF(G5<=3.2,"NONE",IF(G5>=3.2,"CUM LAUDE")))),"")

should work.

 

[Aladin Akyurek]

=IF(I5="Undergraduate",LOOKUP(IF(G5<=3.2,0,G5),{0,"NONE";3.2,"CUM LAUDE";3.5,"MAGNA CUM LAUDE";3.8,"SUMMA CUM LAUDE"}),"Not Applicable")

 

[ddennis]

Many thanks for the tip, it worked!

Regards,

Dion