Excel: Clever formula

Hello Can anyone help me write a single formula that will solve for the total fee to be deducted given this fee card: First 100 - 1.25% Next 200 - 1.00% Next 400 - 0.75% Balance above 700 - 0.50% I have only been able to do it so far using a range of cells. Many thanks Tom

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of March 30, 2015.

For more resources for Microsoft Excel