IF or OR Formula

Melanie Sanders

Hello! I need to return different text based off of another columns answer. If LICENSE CATEGORY is Pharmacy I need PIC/DR TITLE column to = Pharmacy PIC and if the License Category is Distributor or Manufacturing the PIC/DR TITLE column should be Distribution DR. If the it is OTHER then it should be blank. Can someone help with this formula?

Thank you!

S.Stone

@Melanie Sanders try this:

=IF([LICENSE CATEGORY]@row = "Pharmacy", "Pharmacy PIC", IF([LICENSE CATEGORY]@row = "Distributor", "Distribution DR", IF([LICENSE CATEGORY]@row = "Manufacturing", "Distribution DR", IF([LICENSE CATEGORY]@row = "OTHER", "", ""))))

It works on my sample test, but let me know if it works for you.

Kelly Moore

Hey @Melanie Sanders

Try this:

=IF([LICENSE CATERGORY]@row = "Pharmacy", "Pharmacy PIC", IF(OR([LICENSE CATERGORY]@row = "Distributor", [LICENSE CATERGORY]@row = "Manufacturing"), "Distribution DR", IF([LICENSE CATERGORY]@row = "OTHER", "")))

Does this work for you?
Kelly

Melanie Sanders

@Kelly Moore Hi Kelly that doesn't quite work. I seem to be getting an UNPARSEABLE error?

S.Stone

@Melanie Sanders try this:

=IF([LICENSE CATEGORY]@row = "Pharmacy", "Pharmacy PIC", IF([LICENSE CATEGORY]@row = "Distributor", "Distribution DR", IF([LICENSE CATEGORY]@row = "Manufacturing", "Distribution DR", IF([LICENSE CATEGORY]@row = "OTHER", "", ""))))

It works on my sample test, but let me know if it works for you.

Kelly Moore

Hey @Melanie Sanders

Sorry Melanie - I fat-fingered the spelling of your column title. You can usually tell if the unparseable error is from a column name (misspelled or missing) when the column names aren't colored in the formula.

Kelly

Melanie Sanders

@Kelly Moore @S.Stone Thank you both! Works perfectly now :-)