how to set up an IF formula
 

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

how to set up an IF formula
 

Maybe

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

Mike

"Gene" wrote:

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

how to set up an IF formula
 

Gene wrote:
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?

how to set up an IF formula
 

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

"Glenn" wrote:

Gene wrote:
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?

how to set up an IF formula
 

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


"Glenn" wrote:

Gene wrote:
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?

how to set up an IF formula
 

Gene wrote:
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)

how to set up an IF formula
 

Thank YOU Glenn!
--
Gene


"Glenn" wrote:

Gene wrote:
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)