Thread: EXCEL 2003 HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Robert is offline
external usenet poster
 
Posts: 193
Default 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,