I have a small spreadsheet (attached) and in cell K55 I want it to return the highest value from C56:J56 BUT if C56 is the highest value then K55 should show the answer 375. D56 should show Other.
I apologise if my question isn't the clearest.
Thankyou in advance
if you need a maximum the MAX function will do if you need a conditional then IF.
eg =MAX(D56:F56)
click on the * Add Reputation if this was useful or entertaining.
In K55
=IF(C56=MAX(C56:J56),375,MAX(C56:J56))
When do you require D56 to return "Other"? When K55 is 375? If so,
=IF(K55=375,"Other","")
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Is this what you need?
K55=IF(MAX(C56:J56)=J56,375,MAX(C56:J56))
K56=IF(K55=375,"other","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks