using roundup on multiple formulas

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

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you this once https://www.mrexcel.com/board/thread...rmula.1169840/

great works like a dream :-)

Thank you for your help

Apologies, will do in future