Hi Srinivasan,

But I want to know the logic behind 1+307 you used next to match
function

This value is the highest value that can be represented in Excel.

Infact the value is 9.999999999999999E+307

HTH


--
Krishnakumar


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