how to set up an IF formula

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is
(200) and C1 is (100) the result is still 100% but should be (100%). How can
I set-up formula so it correctly recognizes both circumstances?

As always thank YOU.
 
Gene said:
formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is
(200) and C1 is (100) the result is still 100% but should be (100%). How can
I set-up formula so it correctly recognizes both circumstances?

As always thank YOU.
Click to expand...

Why would a negative number divided by a negative number not be positive?
 
why would two netatives not be postive was the question? could be but in
this situation it isn't.

In this circumstance (100) is the budget amount and (200) is the actual
attained. Thus the result is (100%) under budget.

So I'm trying to see if there is a method to reflect this while keeping the
basic formula that usually has other positive or negative results.
 
Gene said:
why would two netatives not be postive was the question? could be but in
this situation it isn't.

In this circumstance (100) is the budget amount and (200) is the actual
attained. Thus the result is (100%) under budget.

So I'm trying to see if there is a method to reflect this while keeping the
basic formula that usually has other positive or negative results.
Click to expand...

Try this:

=(B1-C1)/ABS(C1)
 
Back
Top