Thread
:
#div/0! problem - please help
View Single Post
#
2
garfield-n-odie
Posts: n/a
=if($g1<0,if(($e1+$f1)/$g1=1,1,0),0)
"Alicia" wrote:
I have a formula as follows:
=IF(($E1+$F1)/$G1=1,1,0)
However, if the value in G1 = 0 , then my formula shows #div/0!
How do I solve this?
Alicia
Reply With Quote