how to set up an IF formula

[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.

 

[Mike H]

Maybe

=(B1-C1)/MIN(B1,C1)

Mike

 

[Glenn]

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.

Why would a negative number divided by a negative number not be positive?

 

[Mike H]

Good point, I missed the parenthesis and assumed all No's positive

 

[Gene]

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.

 

[Glenn]

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.

Try this:

=(B1-C1)/ABS(C1)

 

[Gene]

Thank YOU Glenn!
--
Gene

Try this:

=(B1-C1)/ABS(C1)