excel

Almonds Ground - 12.5kg (KB 10kg) 1 £82.92 0 1 2 £83 £26,840 95% 0 no demand OK Macphie Rainbow Frosting - Chocolate - 5kg 6 £13.50 0.2 1 2 £81 £26,921 95% 2 30.0 OK Bako Brownie Mix - 12.5kg 4 £19.61 0.5 1 2 £78 £26,999 95% 7 8.0 OK Granulated Sugar - 25kg 5 £15.62 12 1 2 £78 £27,077 96% 125 0.4 Flag Belcolade Milk Enrobing Chocolate O3X5J disc 2 £38.84 1 1 2 £78 £27,155 96% 26 2.0 OK Puratos Plain Satin Cake Mix - 12.5kg 3 £25.85 2 1 2 £78 £27,232 96% 35 1.5 OK Honey Blended - 25kg 1 £76.61 0 1 2 £77 £27,309 97% 0 no demand OK

Add a layer based on IF (CONDITION, THEN < ELSE) formula ; IF (Condition = your criteria, show this, else do planned calculation)

Copy your formula ‘down’

Getting rid of #DIV0!

You could use conditional

formatting to highlight it

Our condition is where demand is

ZERO

By using “ “ we can put any descriptor

we wish

The original formula