View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Natalie John Natalie John is offline
external usenet poster
 
Posts: 1
Default I'm a Newbie, Need Formula

Here are the requirements

I need one answer with different parameters within one formula

If amount is less than or equal to 100 then answer will be Zero
If amount is more than 100 but less than or equal to 150 then answer will be
8% of the amount exceeding 100
If amount is more than 150 but less than or equal to 300 then answer will be
25 + 12% of the amount exceeding 150
If amount is more than 300 but less than or equal to 400 then answer will be
50 + 20% of the amount exceeding 300
If amount is more than 400 but less than or equal to 700 then answer will be
75 + 25% of the amount exceeding 400
If amount is more than 700 then answer will be 100 + 35% of the amount
exceeding 700