Formula for discount % according the number of procedures

[momchil.vladov]

Hello,

I need a formula to take away a percentage according the amount (number) ot procedures.

For example:

- procedure - price for one - 5 of it - 10% discount - final price

The idea is, for example, if I type amount of 5 procedures, automaticly to make 10% discount, if I type 10 procedure - make 15% discount etc.

Please help. This would be very useful.

[TexasKersh]

%calc.xlsx

Hi

Try the enclosed

TK

[momchil.vladov]

Hi,

Thank You but you didnt understand.

How to make it automatically do the following:
- if the number of procedures is from 5 to 9 to automatically make 5% discount
- if the number is from 10 and above - to make 10% discount and etc.

[sktneer]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[TexasKersh]

%calc.xlsx

Try the enclosed. You can just expand out the columns if you need more discount range i.e. >30. All you need to do is enter price for one item and the number of items.

If my post helps, please remember to click on the reputation button.

Thanks

TK

[momchil.vladov]

Thank You so very much. You've made my life much easier.

[TexasKersh]

Hi, you are welcome

If you consider the post closed, could you click on the thread tools link at the top of the thread and select Thread Solved. If you think I have helped, please feel free to click on the "Add Reputation" link at the bottom left of the post.

Cheers

TK