so

should it be A6/56???

=IF(B6<=15.4,A6/56,(100-B5)/84.5*B5/56)

in stead of B6/56
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56)


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469902