year | £'000 | |||
2012 | ||||
operating profit | 1000 | |||
admin costs | 3000 | |||
cos | 210 | |||
2013 | ||||
operating profit | 1500 | |||
admin costs | 0 | |||
cos | 0 | |||
I want 'average operating margin %' i.e. operating profit/(admin+cos)*100 | ||||
FORMULA | RESULT | BUT RESULT SHOULD BE | ||
=((C4/(C5+C6)*100)+(C9/(C10+C11)*100))/2 | #DIV/0! | 0.16 | ||
My problem - because we are dividing by 0 at (C10+C11), my formula returns an error (as expected) | ||||
What is the fix to my formula so it displays the correct result? Is it to use the logical IF and IS ERROR functions? If so please show me the fix | ||||
nb I do not want to display any intermediate steps. I want to go straight from my data column to a column which displays the result | ||||
Thank you. |