Forum Discussion
jaolvera
Jun 07, 2023Brass Contributor
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...
Patrick2788
Jun 07, 2023Silver Contributor
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,"-")
- jaolveraJun 07, 2023Brass Contributorit references "1/0/1900" when I did the formula. Patrick2788
- Patrick2788Jun 07, 2023Silver Contributor
- jaolveraJun 07, 2023Brass ContributorActually it worked, I had wrong cell referenced. thank you again!