I need a formula!
Posted by Lora on June 08, 2001 8:23 AM
This may not be too hard, but I've been struggling with it for 2 days now, so I need an Excel expert to help me out. I need a formula that will calculate 2.5 percent of the first $100,000 of a figure, 1.5% of the next $400,000 and 1% of everything above $500,000. So if my figure is $585,000, I want the formula to return $9350 ($2500 is 2.5% of $100,000; $6000 is 1.5% of $400,000; and $850 is 1% of $85,000) Can this be done? Thanks for any help you can provide.