IF Based on to and from range

[pmw19800]

hello

in colum G i want an if stament to work out how many pallets there is (looking at the values in colmun F)

below 24 = zero pallets

24 to 48 = 2 pallets

48 to 72 = 3 pallets


thanks in advance

[Fluff13]

How about
=INT(F3/24)

[pmw19800]

when there are 34 boxes it should say 2 pallets, INT(F3/24) is advising 1


it needs to be more acurate
(24 boxes to 48 boxes = 2 pallets)

[Pete_UK]

Try this in G3:

=IF(F3=0,0,INT(F3/24)+1)

Then copy down.

Hope this helps.

Pete

[Fluff13]

Misread the question slightly.
Why is below 24 0 pallets & 24 to 48 2 pallets? What happened to just 1 Pallet?

[Pete_UK]

I also misread that bit - maybe you should use this:

=IF(F3<24,0,INT(F3/24)+1)

Hope this helps.

Pete

[pmw19800]

thanks guys

[Fluff13]

You're welcome and thanks for the feedback