I am using SharePoint 2010.

I added a new Column and made it a Calculated Column.

Now I need to place a CASE statement in my Formula. Something like this...

CASE when [Region1] = 'A' and [Region2] = 'B' THEN
     when [Region1] = 'C' and [Region2] = 'D' THEN

So the value of my Calculated Column will be either YES or NO

3 Answers 3


Rewrite your formula with if-statements and nest them, something like this:


The first if does the first test, if that statement doesn't hold: use the second if (nested in the first if).

  • 1
    isn't the ; the correct parameters separator?
    – Steve B
    Commented Mar 1, 2013 at 10:05
  • 1
    Sadly it depends on the language you are using.
    – Dribbel
    Commented Mar 1, 2013 at 14:45
  • @Dribbel really sadly, here in Brazil the separator is ; it created a lot of difficult to me. Commented Mar 26, 2013 at 15:00

You'll want to use IF statements, look at this MSDN article or this Office document for references. It also helps to mock it up in Excel and then copy/paste it into the calculated column.

Edit: just about had it figured out and Dribble beat me to the formula, nested Ifs which can go up to 7 deep.


The equivalent of CASE in SharePoint is CHOOSE, but it is not very flexible (you need to resort to tricks to convert your cases into numbers). Usually nested ifs work better.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.