bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
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!
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!
