Multiple IF + IF(NOT

Hello and happy New Years to everyone,

I am a little stuck on a formula and would need your help.

Here is my formula: =IF([Column2]@row = "France", IF([Primary Column]@row = "Value 1", "Value A", IF([Primary Column]@row = "Value 2", "Value B", IF([Primary Column]@row = "Value 3", "Value C", IF([Primary Column]@row = "Value 4", " ", IF(NOT([Primary Column]@row = "Value 4", [Primary Column]@row, " ")))))))

What I am trying to do is:

1: If Column 2 = France, I want it to take the value in the primary Column and based on that value, return a different value (translation of the value)

2: If Column 2 is not equal to France, I want it to return the value in the Primary Column, unless the Value = "Value 4", in which case I want it to return blank

Hopefully it's an easy fix. Otherwise I'll use another sheet and vlookup but I'd rather keep it simple.

Thanks in advance,

Julien

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @JDen

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 1"), "Value A", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 2"), "Value B", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 3"), "Value C", "")))

All comments

Bassam Khalil

Hi @JDen

Hope you are fine, please try the following formula and convert it to a column formula.

JDen

Brilliant! That worked!

I did have to complete the code for 2nd Condition but it does what I was looking for. Many thanks!!!!

Bassam Khalil

Hi @JDen

Hope you are fine, i prefer to use Vlookup in your case it will give you more flexibility to manage.

Bassam Khalil

@JDen

You are welcom

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.