Thanks:  0
Likes:  0

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

2. "IF((E6-F6)/E6="0","",(E6-F6)/E6)"

most probably E6 has 0 or no value. Try checking the value of E6 instead of checking the whole formula in the if condition.

3. In addition to what Shalini noted:

Any number including 0 divided by 0 is undefined and Excel renders this as #DIV/0!

An empty cell in math expressions interpreted by Excel as 0.

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

4. your first arguement that says if it's equal to "0" is telling it to recognise a textual value of "0"

even if your (E6-f6/e6) is zero, it's not recognising it as text, and thusly defaulting to your 2nd arguement, which results in a division by zero....

drop the "quotes" or go with Aladin's more compact solution

5. On 2002-04-26 12:26, Chris Davison wrote:
your first arguement that says if it's equal to "0" is telling it to recognise a textual value of "0"

even if your (E6-f6/e6) is zero, it's not recognising it as text, and thusly defaulting to your 2nd arguement, which results in a division by zero....

drop the "quotes" or go with Aladin's more compact solution
Guess what: Dropping the quotes won't help when E6=0 or empty .

6. Guess what : I posted without testing it first.

Naughty Chris

## 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
•