Need help with formula for rounding up

W

wvarner

New Member
Joined
Jun 6, 2011
Messages
9
Cell F17 contains a fixed number (pieces per case pack). My customer will input a number (pieces needed) in cell G17. I need a formula that will round cell G17 up to the nearest case pack (number in cell F17).
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Welcome to the Board...

There will no doubt be a shorter way, but this should do what you want:

=IF(MOD(G17,F17)=0,G17,G17-MOD(G17,F17)+F17)

Matty
 
Upvote 0
One more thing please....I want to hide the #VALUE1 that I get when there is no Data in it. Is that possible?:biggrin:
 
Upvote 0
=IF(or(G17="",F17=""),"",CEILING(G17,F17)) will take care of either F17 or G17 being empty.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Two Value if true, one value if false
Replies
5
Views
365
Joe4
Joe4
A
  • Question Question
Multiple Condition rounding functions
Replies
4
Views
225
FormR
FormR
A
  • Question Question
Round result to a specific ending number
Replies
4
Views
310
Phuoc
P
C
  • Question Question
Conditional formatting using formula to always round up a number
Replies
1
Views
299
arthurbr
arthurbr
S
  • Question Question
Vlookuping matching values with hidden rounding errors
Replies
5
Views
479
awoohaw
awoohaw

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top