SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to use multiple nested IF() functions combined with the OR() function in SharePoint 2010. In Excel 2010 it works very well, but it is not working inside SharePoint. I already tried to use SharePoint Designer 2010 and InfoPath, but didn't work anyway.

The code sample used is:

=IF(OR(A2="Yes",B2="Yes",C2="Yes"),"OK",IF(OR(A2="No",B2="No",C2="No"),"Not OK","Action Pending"))

Thank you,

Rafael Vieira

share|improve this question
Where are you adding this formula? – Ryan Erickson Mar 12 '13 at 22:55
The logic of the formula is flawed or incomplete. If A2=yes, then the result is "OK", but if B2=No then what? Should it be "OK" as per the first IF() or "Not OK" as per the second IF()? Also, your code sample uses Excel style cell references. How does the formula look in your SharePoint setting? Are the columns called A2, B2, C2? Please provide a sample from SharePoint with column names and the formula as you use it in SharePoint. And please provide the context that you are using this formula in. – teylyn Mar 13 '13 at 5:41
How are you trying to apply this formula? It should work fine as a calculated column provided you change the cell references to column references as Teylyn has suggested though I am a little puzzled by the references to SharePoint Designer and InfoPath? – Dave Paylor Mar 13 '13 at 9:11
Hi Teytyn, attached there the XLS file example with Formula working properly: I have tried to apply it as conditional format and Formulas, but the expression IF is not found on that. Thanks. – user15529 Mar 13 '13 at 13:18
I have tried to use the Conditional Formats and apply Formulas, but I can't find the expression IF on that. – user15529 Mar 13 '13 at 13:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.