Forum Discussion

raches ella's avatar
raches ella
Copper Contributor
Jul 18, 2018

Excel IF Statement not working

I have a cell for study participants who are eligible (A2= "Yes" Or "No")

They made a visit a entered in B2=15-AUG-2017. 

I want to create two if statements that calculate a date range for their next visit for those who are eligible in C2. 

 

My logic is this: IF (A2=Yes), then C2 =B2="","",B2+1), 

ELSE "Not eligible". 

 

The next visit has to be the next day. 

 

I would be grateful if anyone one can assist me with this.

excel
Formulas and Functions
Macros and VBA
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 18, 2018

    Hi Raches,

     

    Not sure I understood your logic. If in C2 will be next visit date or "Not eligible" when the formula for C2 is like

    =IF(A2="Yes",IF(B2="","",B2+1), "Not eligible")

Resources