EXCEL 2003 HELP
I NEED TO KNOW IF THIS IS POSSIBLE.
I WANT SOME CELLS TO HAVE A CERTAIN DOLLAR AMOUNT VALUE TO EACH CELL. THIS
SHOULD NOT BE DISPLAYED IN THE CELL.
I WANT THOSE SAME CELLS TO DISPLAY DATES AS I ENTER THEM WHEN THE DATES PASS.
I WANT A SEPARATE CELL TO SUM THE DOLLAR AMOUT FROM THOSE CELLS WITHOUT
BEING AFFECTED BY THE DATES I HAVE ENTERED.
IN OTHER WORDS, I WANT THE CELL TO DISPLAY ONE THING, BUT MEAN SOMETHING
ELSE. IN ADDITION, I DON'T WANT THE CELL TO BE ADDED I THE DESIGNATED "SUM
CELL", SO TO SPEAK, UNTIL I ENTER THE DATE IN THAT CELL.
IS THIS AT ALL POSSIBLE? OR AM I THINKING WAY TOO HARD?
THANKS,
|