Formula to multiply only a portion of a cell number?
 

Is there any way to take only a portion of an amount in a cell and then
multiply it by a number? Let's say that I have $1000 in a cell, but only $50
of it is subject to inflation of 2.5%. I need to find the formula that can
accomplish this task. Thanks, Barb

Formula to multiply only a portion of a cell number?
 

As long as you can define how you get $50 out of the $1000, then the rest is
easy. Is it always 5% of the cell's value?

If so, use:

=a1/20*2.5%

Regards,
Fred.

"zsboppie" wrote in message
...
Is there any way to take only a portion of an amount in a cell and then
multiply it by a number? Let's say that I have $1000 in a cell, but only
$50
of it is subject to inflation of 2.5%. I need to find the formula that
can
accomplish this task. Thanks, Barb

Formula to multiply only a portion of a cell number?
 

The actual numbers a
$67,064 and out of that amount, $4680 is not subject to the 2.5% inflation
rate. $62,384 is what is subject to the 2.5% inflation rate. I cannot
separate the two numbers. I have to keep them totaled and then figure out
the inflation rate only on the $62,384.

"Fred Smith" wrote:

As long as you can define how you get $50 out of the $1000, then the rest is
easy. Is it always 5% of the cell's value?

If so, use:

=a1/20*2.5%

Regards,
Fred.

"zsboppie" wrote in message
...
Is there any way to take only a portion of an amount in a cell and then
multiply it by a number? Let's say that I have $1000 in a cell, but only
$50
of it is subject to inflation of 2.5%. I need to find the formula that
can
accomplish this task. Thanks, Barb

Formula to multiply only a portion of a cell number?
 

=MAX(0,A1-4680)*2.5%


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"zsboppie" wrote in message
...
The actual numbers a
$67,064 and out of that amount, $4680 is not subject to the 2.5% inflation
rate. $62,384 is what is subject to the 2.5% inflation rate. I cannot
separate the two numbers. I have to keep them totaled and then figure out
the inflation rate only on the $62,384.

"Fred Smith" wrote:

As long as you can define how you get $50 out of the $1000, then the rest
is
easy. Is it always 5% of the cell's value?

If so, use:

=a1/20*2.5%

Regards,
Fred.

"zsboppie" wrote in message
...
Is there any way to take only a portion of an amount in a cell and then
multiply it by a number? Let's say that I have $1000 in a cell, but
only
$50
of it is subject to inflation of 2.5%. I need to find the formula that
can
accomplish this task. Thanks, Barb

Formula to multiply only a portion of a cell number?
 

Thank you...it worked!!!!

"Bob Phillips" wrote:

=MAX(0,A1-4680)*2.5%


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"zsboppie" wrote in message
...
The actual numbers a
$67,064 and out of that amount, $4680 is not subject to the 2.5% inflation
rate. $62,384 is what is subject to the 2.5% inflation rate. I cannot
separate the two numbers. I have to keep them totaled and then figure out
the inflation rate only on the $62,384.

"Fred Smith" wrote:

As long as you can define how you get $50 out of the $1000, then the rest
is
easy. Is it always 5% of the cell's value?

If so, use:

=a1/20*2.5%

Regards,
Fred.

"zsboppie" wrote in message
...
Is there any way to take only a portion of an amount in a cell and then
multiply it by a number? Let's say that I have $1000 in a cell, but
only
$50
of it is subject to inflation of 2.5%. I need to find the formula that
can
accomplish this task. Thanks, Barb