G
GBL
Hi:
I'm in need of help expressing a portion of an IF formula without using
a circular reference.
Three columns (B, E, and F) are referenced beginning at row 17. The B and
E columns are formatted as dates while F is formatted as numbers.
If F17 is a zero, then I need E17 to be the same date as B17. If that is
not the case, I want the date in E17 to not change.
Referencing the E17 in the E column creates a circular reference that I
can't seem to avoid.
IF(F17=0,B17,????????????). Any ideas???
I'm in need of help expressing a portion of an IF formula without using
a circular reference.
Three columns (B, E, and F) are referenced beginning at row 17. The B and
E columns are formatted as dates while F is formatted as numbers.
If F17 is a zero, then I need E17 to be the same date as B17. If that is
not the case, I want the date in E17 to not change.
Referencing the E17 in the E column creates a circular reference that I
can't seem to avoid.
IF(F17=0,B17,????????????). Any ideas???