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
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
How about
=INT(F3/24)
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)
Try this in G3:
=IF(F3=0,0,INT(F3/24)+1)
Then copy down.
Hope this helps.
Pete
Misread the question slightly.
Why is below 24 0 pallets & 24 to 48 2 pallets? What happened to just 1 Pallet?
I also misread that bit - maybe you should use this:
=IF(F3<24,0,INT(F3/24)+1)
Hope this helps.
Pete
thanks guys
You're welcome and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks