Forum Discussion

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...

excel

Formulas and Functions

HansVogelaar
Apr 13, 2023
LaMakiry

In D2:

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

Fill down.

HansVogelaar

MVP

Apr 13, 2023

LaMakiry

In D2:

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

Fill down.

LaMakiry

Copper Contributor

Apr 13, 2023

I did:

=IF(A6="", "", ISODD(C6)+(-0.5))

And it seems to be working how I would like! But please let me know if you have something better.