Rounding up

[agoodson56]

I am trying to make a cell round up to the next number if the goes over 48, 96, 144 ect...

I am trying to figure out how many 48 port patch panels I would need. Right now if I need 96 ports it still says 2 and I need it to say 3. The same thing happens if I have 145 it says 3 when I need 4.

My port qty is W34.
The cell I need to have the Patch Panel QTY show up in is J34.

Any help would be great.

 

[dispelthemyth]

assume you have the number 145 in W34 as i think you put then in J34 put

=roundup(W34/48, 0)

 

[agoodson56]

Thank you!