How to write an if or formula with either or return?

I am trying to write a formula that says if the Department column says Pharmacology then return "Pharm" or If Department column says Biology then return "Bio"

Thank you in advance.

This is what I have that isn't working:

=IF(OR(Department@row =Pharmacology, "Pharm",IF(Department@row =Biology, "Bio")))

Find more posts tagged with

Formulas

Cell linking

Accepted answers

Protonsponge

Hello @RPlaud

I think the formula below is what you are looking for.

=IF(Department@row = "Pharmacology", "Pharm", IF(Department@row = "Biology", "Bio", ""))

This formula will give a blank in [Department] if "Pharmacology" or "Biology" are not present in [Department]. If you have more than Pharmacology and Biology you can just add to the IF statements.

All comments

Protonsponge

Hello @RPlaud

I think the formula below is what you are looking for.

=IF(Department@row = "Pharmacology", "Pharm", IF(Department@row = "Biology", "Bio", ""))

This formula will give a blank in [Department] if "Pharmacology" or "Biology" are not present in [Department]. If you have more than Pharmacology and Biology you can just add to the IF statements.

RPlaud

This worked great…thank you so very much!

Protonsponge

Thank you for the follow up, more than happy to help and pleased you got something to work for you.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.