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
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