Hi MIke, this is what i think u need and hope this would do what u r looking
for.

=IF(AND(B43=14.1,B43<=23,D43=45,D43<=87,E43=100 0,E43<=1275),"$75.00",IF(OR(AND(D43=45,D43<=87,E4 3=1000,E43<=1275),AND(B43=14.1,B43<=23,D43=45,D 43<=87)),"$37.5","0.00"))
"edwardpestian"
wrote in message
news:edwardpestian.2b4nr1_1153203304.6836@excelfor um-nospam.com...

Try this. Enter as an array formula


Code:
--------------------


=IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276),"
$75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00"))


--------------------


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=562311