getting div error
hi, I am trying to return the forumale value to "-". see below
D11 cell = 0
F11 cell = 58,000
i am calculating year on year increase in expense where D11=2011 EXPENSE and F11=2012 EXPENSE
formuale used is =SUM(F11-D11)/D11 which returns with #Div/0! error
I want this to change to "-" regardless the D11 or F11 value becomes zero. please help it's looking very odd on my report
I hope i have explained correctly.
thanks for the help in advance
|