=IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>1

M

Mike

Biff helped me but this is the whole formula i need to work
=IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
 
B

Biff

Biff helped me but this is the whole formula i need to work.
=IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
Click to expand...

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

Biff
 
F

FSt1

hi,
try this...
=IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),"$75.00",IF(AND(B44>14,B44<24,D44>44,D44<88),"$37.50","$0.00"))

regards
FSt1
 
E

edwardpestian

Enter as array formula

=IF((B44>14)*(B44<24)*(D44>44)*(D44<88)*(F44>999)*(F44<1276),"
$75.00",IF((B44>14)*(B44<24)*(D44>44)*(D44<88),"$37.50","$0.00"))
 
Top