Forum Discussion

LaMakiry's avatar
LaMakiry
Copper Contributor
Apr 13, 2023
Solved

Formula for Timeline Creation

This question started me off on the right foot but now, I'm afraid I'm stuck. What I am trying to do is create a table where:   if A2 is blank, then D2 remains blank BUT if A2 contains characters A...
  • HansVogelaar's avatar
    Apr 13, 2023

    LaMakiry 

    In D2:

     

    =IF(A2="", "", ISODD(C2)+1)

     

    Fill down.

Resources