# IF Drop Down options with same equation???

Options
✭✭✭

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Are you able to provide screenshots for context?

• ✭✭✭
Options

Yes of course @Paul Newcome.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
edited 10/02/23
Options

Hey Paul,

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

Thanks for the help!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!