Mangesh
I wonder........
How can B131 be smaller than 0 if it is the absolute of A131?

--
Greetings from New Zealand
Bill K

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1pxlue_1117602305.8172@excelfor um-nospam.com...

Another method:
Find the absolute value of you column A, and use your formula on this
second column.

Col B = ABS(A131)
Col C =
=IF(B1310,B131/LARGE($B$131:$B$145,1),IF(B131<0,-B131/SMALL($B$131:$B$145,1),0))


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375313