Calculating formulas according to dropdown list choices

**Giraffeski** · 04-23-2019, 06:42 PM

Hi guys,
I hope someone can help.

I am trying to add formula calculations to a spreadsheet based on different commission rates- I have a dropdown list for 'operators' and each operator has a different commission percentage.
So if cell c3 says 'A' then I want it to calculate one formula, if it says 'B' then I want it to calculate a different one, etc etc. Formulas are just percentages of different cells.
Ive tried doing IF formulas but I'm getting in a muddle and can't get it to work, it keeps returning errors.

Can anyone help me???

**alansidman** · 04-23-2019, 06:59 PM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**jeffreybrown** · 04-23-2019, 07:00 PM

Hello & Welcome to the Forum,

A possible solution >> =IFERROR(CHOOSE(MATCH(C3,{"A","B","C","D"},0),A1*20%,B1*55%,C1*10%,D1*23%),"")

But not knowing what the different formulas are, it's only a guess.

**Giraffeski** · 04-24-2019, 04:53 AM

Thanks for the responses.
Ok, Ive attached a sample file with some made up figures in it but these should show what I need.

So, different operators have different commission agreements, but we may have lots of events with each operator so I just need to be able to select the operator and have it calculate the commission due automatically.

The only formula I haven't worked out yet is how to get the 'if x is less than 400, then £400.