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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!