Remember Me?

#1
May 7th 15, 04:25 AM
 Junior Member First recorded activity by ExcelBanter: May 2015 Posts: 2
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!

#2
May 7th 15, 06:23 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 829
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)

#3
May 7th 15, 08:49 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2015 Posts: 2
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

#4
May 7th 15, 08:51 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2015 Posts: 2
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

#5
May 8th 15, 01:09 AM
 Junior Member First recorded activity by ExcelBanter: May 2015 Posts: 2

Thank you so much!!!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Deanna Excel Worksheet Functions 6 July 30th 07 06:12 PM Lisa Excel Discussion (Misc queries) 6 June 1st 07 03:31 PM Jane Excel Worksheet Functions 7 February 6th 07 05:51 PM babiigirl Excel Worksheet Functions 8 June 14th 06 04:26 PM Korie Excel Worksheet Functions 8 October 6th 05 04:48 PM

All times are GMT +1. The time now is 09:35 PM.