Forum Discussion
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 AND C2 is even, then assign 1, odd assign -1. I'm using these columns to create a timeline. Is this possible?
5 Replies
- 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. - Thank you but I realized by typo above :(. I meant assign -1 if odd.
