P
PAL
Here is what I have:
A2 Milestone 1 Planned
B2 Milestone 1 Actual
C2 Milestone 2 Planned
D2 Milestone 2 Actual
E2 Year (this is the year for the date in D2 or C2)
Using a nested conditionals, I would like the output to be:
Where D2 (or C2 if planned for the future) is in a Year X (from E2), then...
D2 - B2; if there is no data in D2 for calculation, then
C2 - B2; if there is no data in B2, then
C2 - A2; if no data in A2, then blank (don't want to see #value!).
Should these calculations been done separately then put into one column.....
Thanks.
A2 Milestone 1 Planned
B2 Milestone 1 Actual
C2 Milestone 2 Planned
D2 Milestone 2 Actual
E2 Year (this is the year for the date in D2 or C2)
Using a nested conditionals, I would like the output to be:
Where D2 (or C2 if planned for the future) is in a Year X (from E2), then...
D2 - B2; if there is no data in D2 for calculation, then
C2 - B2; if there is no data in B2, then
C2 - A2; if no data in A2, then blank (don't want to see #value!).
Should these calculations been done separately then put into one column.....
Thanks.