% discount structure

Hi there

I am new to this forum and this is my first post. I would appreciate if some of your experts can help me with a formula on this:

Example:

0 - 100 : no discount

above 100 - 200 : 10% discount

above 200 : 20% discount

In other words, if my sum total is of any of the above value, the relevant discount will set in with a discounted value.

Example:

if sum total is 98; Total will be 98.00

if sum total is 108; Total will be 97.20

if sum total is 200; Total will be 180.00

if sum total is 200.1; Total will be 160.08

Appreciate your response.

Thank you.

Hello lorenzsin,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.