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.
Bookmarks