ExcelBanter - =IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441 (https://www.excelbanter.com/excel-worksheet-functions/99810-%3Dif-b44-14%2Ab44-24%2Ad44-44%2Ad44-88%2Af44-999%2Af44-1276-%2475-00-if-b44-1-a.html)

Mike

=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441

Biff helped me but this is the whole formula i need to work.
=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B4414*B44<24*D4444*D44<88,"$37.50","$ 0.00"))

Biff

=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441

"Mike" wrote...
Biff helped me but this is the whole formula i need to work.
=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B4414*B44<24*D4444*D44<88,"$37.50","$ 0.00"))

There's no need to keep starting a new post. Just stay in the original post.

Biff

FSt1

=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441

hi,
try this...
=IF(AND(B4414,B44<24,D4444,D44<88,F44999,F44<12 76),"$75.00",IF(AND(B4414,B44<24,D4444,D44<88)," $37.50","$0.00"))

regards
FSt1

"Mike" wrote:

Biff helped me but this is the whole formula i need to work.
=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B4414*B44<24*D4444*D44<88,"$37.50","$ 0.00"))

edwardpestian

=IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B441

Enter as array formula

=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=562318

All times are GMT +1. The time now is 05:10 PM.