Need help with nested IF and MAX statement

[rob5299]

I'm trying top return a string value based on what MAX looks up. So far what I've got is =IF(MAX(F6,J6,N6,R6)=F6,"BRILLIANT UNCUT",IF(MAX(F6,J6,N6,R6)=J6),"BRILLIANT CUT", IF(MAX(F6,J6,N6,R6)=N6), "PRISTINE UNCUT", "PRISTINE CUT")

Cant get it to accept and I'm hitting a wall.

Trying to determine which type of version of a video game gem I should sell (New World).

The answer for the top line (Jasper) in the attached document is J6, or as I wish to have it outputting "BRILLIANT CUT".

Any help would be great, thanks. Excel was a looong time ago for me haha.

[Crooza]

Hi ,

I assume you're after this

Please Login or Register  to view this content.