IF Drop Down options with same equation???
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.
Best Answer

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))
Answers

Are you able to provide screenshots for context?

Yes of course @Paul Newcome.

How is it supposed to be working? Is the Price Group column a multiselect dropdown?

Yes,
 Choose the price group via drop down.
 Price pops up
 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.
 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

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))

Hey Paul,
Got it! Forgot the other IF statement the first time around.
Thanks for the help!!

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!