If and or excel formula

[pattih]

I need help with this excel formula:
IF(AND(E3=0,F3=0),"-",IF(E3=F3,(E3/D3),IF(F3-F3=0,0,(E3-F3)/D3)))

What I am trying to have the formula do is:
if e3 and f3 are both 0 put a "-" in g3
if e3 = f3 then divide e3/d3 and put the % in g3
if e3-f3=0, then put a 0 in g3
and if none of the above are true that subtract e3 from f3 and divide by d3.

The first 3 statements seem to be working, but the last part is not working for me and I can't figure out what I have wrong in the formula.

Thank you for your help.

 

[par60056]

you are very close. The problem is the last IF. You have F3-F3=0 (Always true) when it should be E3-F3=0

 

[Sanjeev1976]

The formula shows "F3-F3", which should be corrected to "E3-F3" and the revised formula would be :

=IF(AND(E3=0,F3=0),"-",IF(E3=F3,(E3/D3),IF(E3-F3=0,0,(E3-F3)/D3)))

 

[pattih]

Thank you very much for your help. I was able to get the formula to work now!