Hi, I am trying to return a result depending on a drop down list (in google sheets).'
For instance, here's the values in the drop down list:
Standard Class Imprint = .281
Standard Class Live Stamp = .281
First Class Imprint Letter = .455
First Class Indicia = .455
First Class Imprint Card = .284
Standard Class Indicia .281
I have been trying something like =IF(OR(C6="Standard Class Imprint",C6="First Class Imprint Card"),".281",".284") etc etc, but I cannot get it to work, it either errors out, or only chooses the first result.