LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default MATCH with MAX formula question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula help with a match question Jim Excel Discussion (Misc queries) 3 May 12th 09 07:05 PM
Formula/Comparison/Match Question Mark Excel Discussion (Misc queries) 4 May 4th 09 06:32 AM
match formula question Belinda7237 Excel Worksheet Functions 1 September 3rd 08 04:48 PM
match formula question Belinda7237 Excel Worksheet Functions 3 August 21st 08 01:28 PM
Match formula question Belinda7237 Excel Worksheet Functions 6 May 17th 08 03:19 AM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"