Help

If Statements nested with different variables

Topic Labels: Formulas
Solved
Jump to Solution
560 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_Springett
4 - Data Explorer
4 - Data Explorer

What I am trying to do is use 2 nested if statements to check if 2 variables are blank (A and B). If A isn’t blank it will post A, but if A is blank it will then check to see if if B is blank and if B isn’t blank it will post B. But if B is blank as well it will post the safety string C. I thought below would work but its not working.

A and B are cells and C is a string that I have as a safety net.

IF({A} =BLANK(),IF({B}=BLANK(),“C”,B),A)

Any help would be great thanks!

1 Solution

Accepted Solutions
Nick_Springett
4 - Data Explorer
4 - Data Explorer

I figured it out it needs to just be IF(A,A,IF(B,B,C))

See Solution in Thread

1 Reply 1
Nick_Springett
4 - Data Explorer
4 - Data Explorer

I figured it out it needs to just be IF(A,A,IF(B,B,C))