Roundup formula

[petewxm]

Hello All,
Just seeing if someone can help. I`m using a formula to look at another sheet and added 2 cells up (week 19 and week 20) and then increasing this number by 10%, I then want to put a round up formula to round it up to a full pallet of material (105 parts per pallet).

for example I need in week 19 2000 parts and week 20 1000 parts, the calculation would add the together = 3000 parts then add 10% = 3300, a full pallet is 105 parts so would round it up to 3360

=Forecast!J7+Forecast!K7)/100)*110,j3<1,0,roundup(j3/AK3,0)*ak3)

This is the formula which I know is wrong (cell AK3 is where the qty per pallet is)

Thanks

Pete

 

[arthurbr]

Xpost reported

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: using roundup on multiple formulas
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.