Nested IF function

[aazza91]

Hi,

New to the forum as I have a problem with a work sheet that has been bugging me all day.

For example

I want cell H5 to return the number of pallets it would require depending on the number of cases (I5)

We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should return 1. I need to be able to do this up to 10 pallets and with the nested if forumluas I got to 7 and would let me add anymore.

<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="class: xl65, width: 96"]Cases[/TD]
[TD="class: xl66, width: 64"]pallets[/TD]

[TD="class: xl65"]0-126[/TD]
[TD="class: xl66"]1[/TD]

[TD="class: xl65"]127-252[/TD]
[TD="class: xl66"]2[/TD]

[TD="class: xl65"]253-378[/TD]
[TD="class: xl66"]3[/TD]

[TD="class: xl65"]379-504[/TD]
[TD="class: xl66"]4[/TD]

[TD="class: xl65"]505-630[/TD]
[TD="class: xl66"]5[/TD]

[TD="class: xl65"]631-756[/TD]
[TD="class: xl66"]6[/TD]

[TD="class: xl65"]757-882[/TD]
[TD="class: xl66"]7[/TD]

[TD="class: xl65"]883-1008[/TD]
[TD="class: xl66"]8[/TD]

[TD="class: xl65"]1009-1134[/TD]
[TD="class: xl66"]9[/TD]

[TD="class: xl65"]1135-1260[/TD]
[TD="class: xl66"]10[/TD]

</tbody>

 

[Eric W]

Welcome to the forum.

Maybe just:

=ROUNDUP(I5/126,0)

 

[aazza91]

Welcome to the forum.

Maybe just:

=ROUNDUP(I5/126,0)

Just done this and it works a treat - can't believe how simple that was. Thank you!

 

[Eric W]

Glad to help!