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?

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?

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?

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?

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?