Multiple conditions with IF and PARENT ()

Multiple conditions with IF and PARENT ()

Trying to get multiple conditions working with IF + PARENT ()


If formula works when it's used alone.

 =IF([email protected] = "task", "") -> Works

=IF([email protected] = "subtask", PARENT([email protected])) -> Works


However, when I tried to combine the formula, it returns UNPARSEARBLE.

 =IF([email protected] = "task", ""), if([email protected]="subtask", PARENT([email protected])) -> Doesn't work.

What is wrong with above formula?


Best Answer

Answers

Sign In or Register to comment.