Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG, Computer Software Engineer

Category: Programming

Satisfied Customers: 7677

Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

44910485

Type Your Programming Question Here...

ATLPROG is online now

I need help with writing a formula on discount structures.

Customer Question

I need help with writing a formula on discount structures. I would need to attach a file and i'm looking for one formulae which will calculate... if price is greater than 25m then 8% discount applies to the portion greater than 25m, if price is greater than 5m 2% discount applies to the portion greater than 5m etc.

Submitted: 1 year ago.

Category: Programming

Share this conversation

Customer:replied 1 year ago.

(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from yo. Let me know if you need more information, or send me the service offer(s) so we can proceed.

I am working on an answer for you now. So I understand if the item is 28m, 3m is discounted 8%, and 20m is discounted 2%, leaving 5m to be discounted if you choose.

The attached file uses your tiered discount. So you start at the max discount, if greater subtract the floor from the actual price and multiple by the discount rate. sum that with the next rate, if you were more than the first tier, subtract the second tier from the first and multiply by the rate. Let me know if you have questions.