Change formula results

's Computer Specifications

In a query, I have a have fields added together and then divided. When zero
is divided by zero, it gives "#ERROR". I cannot leave the field blank because
it effects other calculations. How do I get the answer to show "0" instead of
"#ERROR"?

's Computer Specifications

=iif(iserr([field1]/[field2],0,[field1]/[field2]))

that should work
--
Never give up, the answer IS out there, it just takes a while to find it
sometimes!

"ridemat" wrote:

> In a query, I have a have fields added together and then divided. When zero
> is divided by zero, it gives "#ERROR". I cannot leave the field blank because
> it effects other calculations. How do I get the answer to show "0" instead of
> "#ERROR"?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula looks OK but results do not change when a component does	Formula looks Ok but results don't chang	Microsoft Excel Crashes	1	9th Apr 2009 10:13 PM
Formula to change calculated results to values	=?Utf-8?B?Q2FtZXJvbg==?=	Microsoft Excel Worksheet Functions	4	24th Jan 2005 08:10 PM
Formula results in font color change	=?Utf-8?B?SmVmZiBQ?=	Microsoft Excel Worksheet Functions	2	1st Nov 2004 08:28 PM
Formula results don't change anymore	Amanda	Microsoft Excel Worksheet Functions	4	5th Jan 2004 02:55 AM
Change the way results of formula are displayed?	John Oliver	Microsoft Excel Misc	7	20th Aug 2003 04:04 AM