I am trying to figure out a way to calculate data in a cell if the date is
current, or leave it alone (no operation) if it isn't. Basically I am using a
table to calculate test execution data. It would look something like the
following:
A B
1 96% 90% (data calculated on 3/1)
1 95% 89% (data Claculated on 3/2 in the same cells as above)
I then have another table that stores the data (manually right now) so that
I can graph it daily as follows:
A B C
5 3/1 96% 90%
6 3/2 95% 89%
What I was trying to do in B5 was =if(A5=TODAY(),A1,IF(A5<TODAY(),leave the
cell alone.
I can't seem to figure out a way to do this.
Help!!!
Bookmarks