getting div error

		Microsoft Office Forums > Microsoft Excel > Excel
getting div error

07-26-2011, 06:28 AM

Catalin.B

Windows Vista getting div error

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Normally, you dont need SUM in this formula =(F11-D11)/D11
To remove the error:

Try this: =IF(ISERR((F11-D11)/D11*100)=TRUE;"-";(F11-D11)/D11*100)

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.