Hi Bill,

You are right. I didn't take a second look at the formula. Just saw that
using the ABS() will solve the problem of the OP.

Mangesh



"Bill Kuunders" wrote in message
...
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