IF Drop Down options with same equation???

Andrew Watts

Hey there,

I'm having trouble solving this equation. I have a series of dropdowns all pulling VLOOKUP numbers which is then making the same equation. There are three options in the drop down. My equation works if I have only one "Price Group" Option but when I have more the equation stops working.

Any help!!???

=IFERROR(IF([Upholstery Price Group]@row = "Price Group 01", [Upholstery Price Group]@row = "Price Group 02", [Upholstery Price Group]@row = "Price Group 03", [Upholstery Price (DKK)]@row * [Consumption (RM or SM)]@row, IF([Upholstery Price Group]@row = "Open Price", [Open Price (DKK)]@row)), "0.00 kr.")

Thanks in advance.

Paul Newcome

Ok. I think I understand what you're going for now. You will need an OR statement, or we can shorten things up a little bit using an AND statement or rearranging the IFs.

My suggestion would be...

=IF([Price Group]@row <> "", IF([Price Group]@row = "Open Price", open_price_calc, specific_price_calc))

Paul Newcome

Are you able to provide screenshots for context?

Andrew Watts

Yes of course @Paul Newcome.

Paul Newcome

How is it supposed to be working? Is the Price Group column a multi-select dropdown?

Andrew Watts

Yes,

1. Choose the price group via drop down.
2. Price pops up
3. You can also choose 'open price' at the bottom of the drop down list if you want to override the VLOOKUP. You can then put any price in the override cell.
4. The consumption price is then calculated Upholstery price * Consumption (RM or SM).

I'm looking for the correct formula so any of the drop down price groups still calculate the upholstery * the consumption amount.

Not sure if that uses and IF(OR formula or am just missing something.

Thanks

Paul Newcome

Ok. I think I understand what you're going for now. You will need an OR statement, or we can shorten things up a little bit using an AND statement or rearranging the IFs.

My suggestion would be...

=IF([Price Group]@row <> "", IF([Price Group]@row = "Open Price", open_price_calc, specific_price_calc))

Andrew Watts

Hey Paul,

Got it! Forgot the other IF statement the first time around.

Thanks for the help!!

Paul Newcome

Happy to help. 👍️