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.
Enter data for approximately 20 customers and automatically calculate their discount
I need the formula for this, please help. I also need to identify the Top Customer. Thank you.
Without being too vague, a sample workbook may be needed for further help.
Spread the love, add to the Rep
"None of us are as smart as all of us."
It is best that you provide an accurate sample of the format of how your spreadsheet is laid out. Without that, it is impossible to predict what columns you are using and we could be going back and forth needlessly.
You could also upload an accurate sample of your file.
If I helped in any way, please click the star
Attached is the question. I have no workbook in particular as I am meant to create one. Hope this helps, thanks. image001.gif
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks