Thanks:  0
Likes:  0

# Thread: #DIV/0! Error

1. 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,"")

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

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

4. 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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•