View Single Post
 
Old 07-26-2011, 04:42 AM
accablues accablues is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jul 2011
Posts: 3
accablues is on a distinguished road
Default 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
Reply With Quote