Formula to multiply only a portion of a cell number?

[zsboppie]

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

 

[Fred Smith]

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]

The actual numbers are:
$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.

 

[Bob Phillips]

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


--
---
HTH

Bob


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

 

[zsboppie]

Thank you...it worked!!!!

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


--
---
HTH

Bob


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