# Need help with creating conditional formula with percentage

1. ## Need help with creating conditional formula with percentage

Hi,

I am new to the forum and have only basic knowledge of Excel. I am trying to figure out how to create a conditional formula, and would be very grateful for your help. Basically, I am trying to calculate a commission on a sales price where the commission is 3% of the sales price if the sales sum is 1.100.000 or less, and 10% commission on any amount exceeding 1.100.000. So, I'm looking for something like:
If < than 1.100.000, then I want it the cell to return the value of 3% of 1.100.000. If > 1.100.000, then I want the cell to return 3% of 1.100.000 PLUS 10% of any amount that exceeds 1.100.000. Does that make sense?

Any help appreciated!   Register To Reply

2. ## Re: Need help with creating conditional formula with percentage

You can use VLookup for that.

an excel file, without confidential information will also help to get an better result.  Register To Reply

3. ## Re: Need help with creating conditional formula with percentage

Try this:

=(A1*3%)+(MAX(0, A1-1100000)*7%)  Register To Reply

4. ## Re: Need help with creating conditional formula with percentage

Thanks, I looked up VLookup but I still cant figure out how to do it. I set cell C28 to 1040000 and then tested this formula: =IF(C28>1100000,3%, IF(C28>1100000,10%)), but then I got the output FALSE. I don´t get it, according to my logic the output should then be 3% of 1040000?

And in any case the formula would still not work for me because if it is over 1100000 it should not be 10% of the whole sum, but of the amount exceeding 1100000.

Let me underscore that I am extremely amateurish at Excel, so I need to have it explained like a 5-year old....

Anyone?  Register To Reply

5. ## Re: Need help with creating conditional formula with percentage

Perfect! That worked! Thank you so much!   Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 