Excel multiply 1 number by different rates.

[SeaweedOPM]

I know this has to be something simple, it is similar to compounding. I have one number lets say 13,000 and want to multiply the first 5,000 by .6 the next 2,000 by .5 the next 2,000 by .3 and so on. What is the formula for what I want to do?

 

[SkipVought]

Hi,

"I have one number lets say 13,000"

I take that to mean that you have a single value of 13,000 in a cell somewhere.

"...want to multiply the first 5,000 by .6..."

the first 5,000 of WHAT?

Your question is not clear at all.


Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[KenWright]

http://cpearson.com/excel/pricing.htm

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SeaweedOPM]

KenWright,


Thanks man, Thats perfect.

 

[KenWright]

You're welcome

Chip's site is an amazing resource, so well worth bookmarking and then trawling through the Index.

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------