| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Function
I am trying to create a formula that will multiply a portion of a cell by a
percent and the other portion by another percent. For example, when the value reaches $10,000 I want it to multiply by a different percent. So, if the value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Function
How about something like this, which assumes your $10K or $20K is in A8
=IF(A8<=10000,A8*0.1,((10000 *0.05) +((A8-10000)*0.1))) "Lisa H" wrote: I am trying to create a formula that will multiply a portion of a cell by a percent and the other portion by another percent. For example, when the value reaches $10,000 I want it to multiply by a different percent. So, if the value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Function
=IF(A1<=10000,A1*0.05,((A1-10000)*0.1)+(10000*0.05))
Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 11:31:01 -0700, Lisa H <Lisa wrote: I am trying to create a formula that will multiply a portion of a cell by a percent and the other portion by another percent. For example, when the value reaches $10,000 I want it to multiply by a different percent. So, if the value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Function
Jerry
One of us has it wrong way 'round<g Gord On Wed, 22 Apr 2009 12:33:01 -0700, JLatham wrote: How about something like this, which assumes your $10K or $20K is in A8 =IF(A8<=10000,A8*0.1,((10000 *0.05) +((A8-10000)*0.1))) "Lisa H" wrote: I am trying to create a formula that will multiply a portion of a cell by a percent and the other portion by another percent. For example, when the value reaches $10,000 I want it to multiply by a different percent. So, if the value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%. Any ideas? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Function
I just took a guess, figuring I had a 50/50 chance of getting it right and
that if I was wrong, that Lisa H would compensate for my dense state of mind. "Gord Dibben" wrote: Jerry One of us has it wrong way 'round<g Gord On Wed, 22 Apr 2009 12:33:01 -0700, JLatham wrote: How about something like this, which assumes your $10K or $20K is in A8 =IF(A8<=10000,A8*0.1,((10000 *0.05) +((A8-10000)*0.1))) "Lisa H" wrote: I am trying to create a formula that will multiply a portion of a cell by a percent and the other portion by another percent. For example, when the value reaches $10,000 I want it to multiply by a different percent. So, if the value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting on sum function not on A1+A3 | Excel Discussion (Misc queries) | |||
| Conditional Function | Excel Worksheet Functions | |||
| Conditional function | Excel Worksheet Functions | |||
| conditional MIN() function | Excel Worksheet Functions | |||
| How do I set up a conditional function in Excel | Excel Worksheet Functions | |||
Linear Mode
