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

[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"))

[Biff]

"Mike" wrote...
> 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"))

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

Biff

[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

"Mike" wrote:

> 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"))

[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"))