If statement confusion

Here is the challenge I face:
Discount program based on spending

column b (1st 2nd 3rd 4th qtr spending)
column c (discount percentage based on spending)
IF 1st qtr $ is >10000 and <24999 then discount for 2nd qtr = 2.5%
IF 1st qtr $ is >=25000 and <49999 then discount for 2nd qtr = 5.0%
IF 1st qtr $ is >=50000 and <74999 then discount for 2nd qtr = 7.5%
IF 1st qtr $ is >=75000 and <200000 then discount for 2nd qtr = 10.0%

Then in the 2nd qtr I need to add 1st and 2nd qtr spending and compare amount for discount percentage and do the calculation (discount applies to the following qtr)
Then in the 3rd qtr I need to add 1st and 2nd and 3rd qtr spending and compare amount for discount percentage and do the calculation (discount applies to the following qtr)
Same applies to the 4th qtr

Can someone assist me? I'm sure you pro's can do it in an instant. It would save me time and aggravation. LOL

column d (calculated savings based on discount level)

If the 1st qtr $ is in A1, this will return the discount for 2nd qtr

Please Login or Register  to view this content.

You didn't say what you wanted for over 200,000

Thank you very much.