On Wed, 28 Apr 2010 15:33:02 -0700, RENEE
wrote:

Tried that one out and it works perfectly. Thanks so much!!!!

Personally, I would not do this with an inline formula. I would write
a little UDF. Then, instead of a complicated formula that mau not make
any sense to you in 6 months, each cell would have something like:

=VarPC(A1)

You can put as much commentary as you like in the UDF and if you ever
decide to change any of the parameters, you just change one function
and all of the cells are updated. You can also add other arguments if
you need any variability.

"Rick Rothstein" wrote:

Assuming your $7,417 value is in A1, I think this formula does what you
want...

=0.667*MIN(A1,2500)+0.5*MIN(MIN(A1-2500,3500),6000)+0.4*MAX(A1-6000,0)

--
Rick (MVP - Excel)



"RENEE" wrote in message
...
Could someone please!!! help me to set up a complex formula which I will
use
many times over.

I have an amount - say $7,417. I need to take 66.7% of the first $2,500
(which comes to $1,667.50). This leaves me with $4,917 of the original
amount and I need to take 50% of the next $3,500 ($1,750) - leaving me
with
$1,417 of the original number which I need to take 40% of ($566.80) Then,
I
add all the percentages up to come to $3,984.30. I have to do this a lot
and
could certainly use an easier way other than a calculator and a large
sheet
of paper. Thanks.

.