Excel and Sum Combinations

[trainer75]

Hi everyone,
Hope someone can assist me with this one.

I am pulling together a report and i need to work out a formula from a changing input.

For example
If i am ordering 1 pallet of apples with 16 on a layer with 5 layers i would like a formula to say that if the order is in combinations of 16 (16,32,48, 64 etc) then its ok (then condition format will fill cell green) but any other quantity around them numbers is not ok and will fill cell with red.

That might be the easy part, the "16" im talking about will come from a already worked out formula which will change per line.

Does that make any sense?

I have tried the Ceiling function but unfortunately my skill with this level of formula are not up to scratch yet.

Thanks in advance if anyone can help

Regards,

 

[gaz_chops]

Post a sample of the data, as its laid out and what results you expect. See my signature for how.

 

[trainer75]

Hi there, i cant seem to update my excel data sheet.
my system wont allow it.

Post a sample of the data, as its laid out and what results you expect. See my signature for how.

 

[trainer75]

My end goal is for a column to say whether the quantity picked matches what is on a layer of the product that is selected.
For example
SKU Description Pallet Layer HI Full Plts Layer Cases Ordered
5361234 BAKED BEANS 420G - AMB 96 16 6 0.13 0.8 12
1854561 Q/CK SPAGTTI 500G - AMB 150 30 5 0.27 1.3 40
2097122 CORN FLAKES 500G - AMB 40 10 4 0.58 2.3 23
3629876 PLAIN FLOUR 1.5KG - AMB 78 13 6 0.03 0.2 2
4886567 SLCD BTROOT 710G - AMB 180 20 9 0.07 0.7 13

Where the layer says 16, 30 etc I want to be able to type in the cases ordered whatever quantity and if it is in multiples of the layer if comes back green, so the first one if cases ordered are 16, 32, 48 etc it will be green and any others will come back as red.

does this make sense?