View Single Post
  #1   Report Post  
Old June 29th 09, 12:56 AM posted to microsoft.public.excel.misc
Amaren Amaren is offline
external usenet poster
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default Calculate Amount with Varying Percentages per Thousands

Does anyone know how to write a formula that would update my compensation
number based on the following:

I get 25% of the first $1,000
Then 26% of $1,001 to $2,000
Then 28% of $2,000 to $5,000

I want to be able to update the amount I made for my company (i.e. $12,355)
in one cell and then have a formula that would calculate my bonus based on
those percentages per thousand in another cell?
I am rusty on my formula writing and need some help!!!