Thread: [Solved] If statement question
View Single Post
 
Old 06-04-2014, 07:38 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default
Yeah, I think so, if I understand the question. Let's say the ranks are in column E. Then for any rank=1 you use =IF(En=1,"Low","Something else"), and for rank=<highest> you use =IF(En=MAX(E:E),"High","Something else"). How's that?
Reply With Quote