I am looking for a more efficient formula as I have to this manually due to different criteria per product tariff
see attached
very tedious when you have 1000 to 2000 rows of data
that is quantity *packing*product litrage =litres header but if packing header is 0 same multiplication formula in litres header gives 0.
So I have to make this manually quantity *product litrage =litres header
A better formula to do this
2.if headers packing,product litrage empty then show nothing in litres header
3.A bit tricky if litres header has value and if sugar g/l has a value then multiply litres header *sugar g/l for sugar header to be filled otherwise if sugar g/l is bLANK BUT %ALCOHOL header has a value then * litres headers put value alcohol .
4. if packing, product litrage , sugar g/l ,% alcohol headers are blank, show nothing in litres ,sugar and alcohol headers .
Summary If there is data is sugar g/l header then multiply by litres header add value in sugar header otherwise if sugar g.l header is blank but % alcohol has value then * multiply by litres header add value in alcohol header.
if column D to G IS EMPTY , do nothing show blank column I to K .
Bookmarks