Sharepoint - Calculated Column using IF OR AND

Question

Sharepoint - Calculated Column using IF OR AND

Lincoln Raad 21

Hi guys, I need some help with the syntax to create a calculated column in SharePoint.

Considering columns A, B, C and D, I need to calculate a new column with the following logic:

if A="aaa" and (B="bbb" or C="ccc" or D="ddd") then

New Column=X

if not

New Column=Y

Example:

A="aaa"
B="bbb"
then
Result X

A="aaa"
C="ccc"
then
Result X

A="ttt"
C="ccc"
then
Result Y

A="aaa"
B is not "bbb"
C is not "ccc"
D is not "ddd"
then
Result Y

Thank you very much

Accepted answer

0 additional answers

Your answer

Answer 1

Allen Xu_MSFT 13,866

Hi @Lincoln Raad ,

Use this formula in your calculated column:

=IF(AND(A="aaa", OR(B="bbb", C="ccc", D="ddd")), "X", "Y")

----------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Allen Xu_MSFT 13,866 Reputation points

2022-01-31T08:15:08.22+00:00

@Lincoln Raad ,

Did you use the formula in my above answer? Would it be helpful to you? Comment here if you still need any help.

Share via

Sharepoint - Calculated Column using IF OR AND

0 additional answers

Your answer