Marshall Scmidt

Posts: n/a

How do I get rid of the #/DIV/0! message

If I have a formula say (A2+A10)*A12/A15 if A15 is blank it returns
#/DIV/0!, how do i get it to return 0
--
Marshall

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
Calculations And Order In Macros	Carl Bowman	Excel Discussion (Misc queries)	4	February 23rd 05 10:53 PM
when opening excel I receive a message that says file can't be fo.	Ken	Excel Discussion (Misc queries)	3	February 22nd 05 12:13 AM
changing the message in an error message	The Villages DA	Excel Worksheet Functions	2	February 18th 05 05:30 PM
Error Message appearing when saving a file	JaneC	Excel Discussion (Misc queries)	0	November 25th 04 10:35 PM
#num! error message	Frank Kabel	Excel Worksheet Functions	0	November 18th 04 07:07 PM

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

About Us

"It's about Microsoft Excel"