getting div error

accablues · #1 07-26-2011, 04:42 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Ms Word Error	manesh	Word	1	05-28-2010 07:26 AM
Circular error	markg2	Excel	2	05-17-2010 07:39 AM
Runtime error 5487 - Word cannot complete the save to to file permission error	franferns	Word	0	11-25-2009 05:35 AM
Receive error cannot open this form because an error occurred in BCM 2007	bornhusker	Outlook	0	06-01-2009 10:28 AM