Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Jun 07, 2023

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...
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 07, 2023

jaolvera 

Using named ranges

= IF(symptomatic="Yes", onsetDate, episodeDate)

or, borrowing from Patrick,
= SWITCH(symptomatic, 
      "Yes", onsetDate, 
      "No",  episodeDate, 
  "")

 

Resources