#DIV/0! Error

Aladin Akyurek · Jan 14th, 2002, 04:51 PM

Quote:

On 2002-01-14 16:21, Patrick wrote:
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

Try:

=IF(E6,(E6-F6)/E6,"")

Patrick · Jan 14th, 2002, 05:21 PM

Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

Aladin Akyurek · Apr 15th, 2002, 10:00 AM

In case you didn't see any reply...

Jay Petrulis · Apr 15th, 2002, 10:47 AM

Quote:

On 2002-01-14 16:21, Patrick wrote:
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

Hi,

Aladin already provide the solution, but the reason you are receiving a #DIV/0! error is because your test condition is comparing the result of a calculation with a string, not a number. So, the FALSE condition occurs and you return a result that divides by zero.

Aladin's formula is much nicer, but you can achieve the same thing you want by removing the quotes around the zero.

Bye,
Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 05:21 PM	#2
Patrick Board Regular Join Date: Mar 2002 Location: Canada Posts: 50	Can anyone tell me why this insists on bringing up the #DIV/0! Error =IF((E6-F6)/E6="0","",(E6-F6)/E6)

Apr 15th, 2002, 10:00 AM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	In case you didn't see any reply...