Posted to microsoft.public.excel.misc

joey_boy

external usenet poster

Posts: 2

Divide by 0 Help

=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.

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
Divide By	Dewayne	Excel Discussion (Misc queries)	6	June 17th 09 06:46 PM
divide by zero	arknsparc	Excel Discussion (Misc queries)	1	April 22nd 09 08:15 PM
divide	Marc	Excel Discussion (Misc queries)	2	September 22nd 06 02:34 AM
divide by 0	sony654	Excel Worksheet Functions	4	April 24th 05 08:10 AM
Divide one row over other row I dont wont to divide one number	Rick	Excel Discussion (Misc queries)	0	March 4th 05 07:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us