Microsoft Office Forums - View Single Post - How can I calculate price discounts and also identify top customer?

Thread: How can I calculate price discounts and also identify top customer?

View Single Post

Old

12-24-2014, 12:16 PM

cwarfox

cwarfox is offline

cwarfox uses Windows Vista

Windows Vista cwarfox uses Office 2007

cwarfox uses Office 2007

Office 2007

Novice

The original poster

Join Date: Dec 2014

Posts: 1

cwarfox is on a distinguished road

Question

How can I calculate price discounts and also identify top customer?

There are three levels of discount: 5% when customer sales reach £500, 10% when customer sales reach £1000 and 15% when customer sales reach £2000. What's the formula to automatically calculate their discount? I also need to identify the Top Customer. Thanks

Reply With Quote