Help ASAP with formula!
 

Hello!

So I am having a really BIG problem coming up with a formula..

Here's the issue:
I have a number in E11 that is negative. I'm trying to subtract two percentages that are in E7 & E9 to this negative number to reduce it and make it go positive.

Here's an example of what I mean: -654 - 58% - 7.125% = -255.10
E7 = 7.125%
E9 = 58%
E11 = -654
E13 = Total(-255.10)

What is a good formula for this?

Thanks!

Help ASAP with formula!
 

"LouisCG3" wrote:
Here's the issue:
I have a number in E11 that is negative. I'm trying
< to subtract two percentages that are in E7 & E9 to
this negative number to reduce it and make it go positive.

Here's an example of what I mean: -654 - 58% - 7.125% = -255.10

Apparently you want: -654*(1-58%)*(1-7.125%)

But that does not "make it go positive".

I assume you mean it something like: "reduce" it in a positive direction".
Really, you want to reduce the __magnitude__ of the number.


"LouisCG3" wrote:
E7 = 7.125%
E9 = 58%
E11 = -654
E13 = Total(-255.10)
What is a good formula for this?

=E11*(1-E9)*(1-E7)

Help ASAP with formula!
 

Hi,, Try this


=(E11-(E11*58%))-(E11-(E11*58%))*7.125%






On Thursday, May 7, 2015 at 9:19:05 AM UTC+5:30, LouisCG3 wrote:
Hello!

So I am having a really BIG problem coming up with a formula..

Here's the issue:
I have a number in E11 that is negative. I'm trying to subtract two
percentages that are in E7 & E9 to this negative number to reduce it and
make it go positive.

Here's an example of what I mean: -654 - 58% - 7.125% = -255.10
E7 = 7.125%
E9 = 58%
E11 = -654
E13 = Total(-255.10)

What is a good formula for this?

Thanks!




--
LouisCG3

Help ASAP with formula!
 

or use this

(E11-(E11*E9))-(E11-(E11*E9))*E7


On Thursday, May 7, 2015 at 9:19:05 AM UTC+5:30, LouisCG3 wrote:
Hello!

So I am having a really BIG problem coming up with a formula..

Here's the issue:
I have a number in E11 that is negative. I'm trying to subtract two
percentages that are in E7 & E9 to this negative number to reduce it and
make it go positive.

Here's an example of what I mean: -654 - 58% - 7.125% = -255.10
E7 = 7.125%
E9 = 58%
E11 = -654
E13 = Total(-255.10)

What is a good formula for this?

Thanks!




--
LouisCG3

Thank you so much!!!