Forum Discussion
IF formula
Hello, I needed a formula that would reference one of 2 dates. so if column Q contains "Yes" then reference the date in column R, or if Column Q contains "No" then reference date in cell O. Thank you...
Perhaps this one (You can change out the "-" with any desired text to show if the cell is neither "yes" or "no":
=SWITCH(Q2,"yes",R2,"no",O2,"-")
it references "1/0/1900" when I did the formula. Patrick2788
- Actually it worked, I had wrong cell referenced. thank you again!
- You're welcome!