Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm hoping someone can help. I have the following formula in a spreadsheet:
=IF(MATCH(MAX(C22:G22),C22:G22,0)=1,"Low Complexity",IF(MATCH(MAX(C22:G22),C22:G22,0)=3,"Mo derate Complexity",IF(MATCH(MAX(C22:G22),C22:G22,0)=5,"Hi gh Complexity",""))) The problem I have is that if I have the same return number in both Moderate and High cells (E22 & I22 respectively), it returns Moderate - ideally I would like it to return High when the numbers are the same. How do I accomplish this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula help with a match question | Excel Discussion (Misc queries) | |||
Formula/Comparison/Match Question | Excel Discussion (Misc queries) | |||
match formula question | Excel Worksheet Functions | |||
match formula question | Excel Worksheet Functions | |||
Match formula question | Excel Worksheet Functions |