han77729
New member
- Joined
- Dec 12, 2012
- Messages
- 31
- Reaction score
- 0
- Points
- 0
Hello All,
Please assist if you can. This is what I'm trying to get..
What I'm trying to do is to get Column C~N to pick up a IF statement based off of data coming from Column A and B.
Let's take A2 and A3 for example..
If A3 is empty.. Then C2:N2 will output B2/12 all throughout Row 2 to Column N (Dec.)
Now..
If A3 has a date (this date will always be greater than the previous Aug-13 in this case, then it will start the calculation at J2 (Aug.) going through N2
I hope this explains what I'm trying to do..
I've tried to use IF and Lookup formula but it just doesn't work and I can't get the logic right..
Please support,
Please assist if you can. This is what I'm trying to get..
What I'm trying to do is to get Column C~N to pick up a IF statement based off of data coming from Column A and B.
Let's take A2 and A3 for example..
If A3 is empty.. Then C2:N2 will output B2/12 all throughout Row 2 to Column N (Dec.)
Now..
If A3 has a date (this date will always be greater than the previous Aug-13 in this case, then it will start the calculation at J2 (Aug.) going through N2
I hope this explains what I'm trying to do..
I've tried to use IF and Lookup formula but it just doesn't work and I can't get the logic right..
Please support,