| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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")) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
