Kenny16301 via OfficeKB.com

Posts: n/a

#DIV/0! Error

Hi,

In the formula listed below sometimes I put zeroes in the 2 cells or I leave
them blank but I get the #DIV/0! error. How can I add the ISError function to
my formula. Its driving me crazy.

=SUM(B14-C14)/B14

Thanks In advance.
Kenny

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Div/0 error	scott45	Excel Worksheet Functions	4	September 9th 05 04:21 PM
DIV/0! error in SumProduct formula with no division	Irrational	Excel Worksheet Functions	1	August 18th 05 01:39 AM
replace "#DIV/0!" error with blanks	Mark B	Excel Worksheet Functions	0	June 22nd 05 10:19 AM
# DIV/0! error in Excel	Helpwanted	Excel Discussion (Misc queries)	8	May 6th 05 09:31 PM
"Average" with error DIV/0	agenda9533	Excel Discussion (Misc queries)	1	March 2nd 05 05:47 PM

All times are GMT +1. The time now is 11:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us