Hi!

If there are multiple instances of rank1 that will not give the results that
it seems the OP wants.

Biff

"Krishnakumar"
wrote in message
news:Krishnakumar.1v33mg_1126256766.0858@excelforu m-nospam.com...

Hi,

=IF(B1=1,A1-LARGE($A$1:$A$4,2),A1-LARGE($A$1:$A$4,1))

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=466162