Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
Thank you so much!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula assistance ASAP | Excel Worksheet Functions | |||
Formula Help-ASAP | Excel Discussion (Misc queries) | |||
ASAP - need help with formula! | Excel Worksheet Functions | |||
Complicated formula please help asap! | Excel Worksheet Functions | |||
Need a Formula ASAP | Excel Worksheet Functions |