Can't you turn it the other way round, put the High IF comparison first, then
the moderate then the low?

"Spongie" wrote:

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