AMY Z.

Posts: n/a

Simple #DIV/0! error

Hi,
A1=0
A2=0
A3=A1/A2
A3 returns the #DIV/0! error.
What are the functions or syntax I have to use for A3 to return 0 if A1 and
A2 are 0?

I looked in Excel help and tried nesting the IF function and ISERROR
function but I can't get the syntax right.

Thanks for your time, whilst everyone have a nice weekend,
Amy

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
Findlink Error	D Moniz via OfficeKB.com	Links and Linking in Excel	0	January 20th 05 04:53 PM
Error when entering and exiting excel	Randy	Excel Discussion (Misc queries)	1	January 11th 05 03:17 PM
#DIV/0 Error	Dominique Feteau	Excel Worksheet Functions	2	December 19th 04 08:06 AM
Please help correct a simple error	lwhite	New Users to Excel	1	December 9th 04 09:39 PM
#REF error	Christen	Excel Worksheet Functions	5	November 3rd 04 07:29 PM

All times are GMT +1. The time now is 07:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us