Between 13 and 24 I would like the formula to return 1/2 Pallet.

Thanks for the help,
Tom

"Teethless mama" wrote:

=IF(B3<6,"Carton",IF(B3<12,"1/2 Pallet,IF(B3=25,"Full Pallet","")))

What do you want the result if B3 is between 13 and 24


"tom" wrote:

I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,