Reply With Quote"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.
Thanks: 0
Likes: 0
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)
"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.
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.
Rewrite your formula as:
=IF(E6,(E6-F6)/E6,"")
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
:: Pharma Z - Family drugstore ::
Guess what: Dropping the quotes won't help when E6=0 or emptyOn 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 : I posted without testing it first.
Naughty Chris
Like this thread? Share it with others