if(and(or...issue

[bluepenink]

Hello

having some logic placement issue with my formula.

basically, here is the scenario.

=IF(D53=$E$53,"-",D53-D46)

where D53 = 50%
E53 = "MAX"
D46 = 80%

=IF(AND(D53=$E$53,D53>D46),"-",D53-D46)

in the example above, d53-d46 = -30%, so, i want to be able to say,
if D46 is > D53, then make it, D46-D53, while also, keeping the original formula D53=$E$53,"-",

can someone pls help!

 

[bluepenink]

any suggestions guys?

 

[Michael M]

First question
D53 will never = E53 while E53 is text.
E53 needs to be a numerical value for this to work.
If that can be rectified, I think you need

=IF(AND(D53=$E$53,D53>D46),"-",IF(AND(D53=$E$53,D46>D53),D46-D53,D53-D46))