Menu

#DIV/0! error message

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Stan Brown Stan Brown is offline

Stan Brown is offline

external usenet poster

Posts: 524

Default

#DIV/0! error message

Sat, 5 May 2007 18:00:00 -0700 from <?B?Q2FsdmluYSBIYXllcw==?
= <Calvina :
Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message.

You're making it too hard on yourself. The error condition arises
when B2 is zero, so change your first formula to
=if(B2=0,"",sum(C2-B2)/B2*100)

But there's an additional problem: your sum(C2-B2) doesn't make sense
because you are summing one number. I suspect you messed up some
parentheses somewhere. If you don't see your error, can you tell us a
little more about what you're trying to do?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Error Message Box	Daviv	Excel Discussion (Misc queries)	1	January 25th 07 07:03 PM
VBA Error Message "Compile Error...."	Steve	Excel Discussion (Misc queries)	3	July 15th 05 09:20 AM
changing the message in an error message	The Villages DA	Excel Worksheet Functions	2	February 18th 05 05:30 PM
Help with error message - please!	Pat	Excel Worksheet Functions	4	January 29th 05 10:16 AM
How do I get rid of "Compile error in hidden module" error message	David	Excel Discussion (Misc queries)	4	January 21st 05 11:39 PM

All times are GMT +1. The time now is 12:28 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement