Excel formula?????
 

This seems like a simple scenario although to get it to work on excel seems
impossible.

Here goes.. i would like to set up a spread sheet whereby i could type in
the various forecasts sales for the week from cells A1 to A7 say. I would
however like the numbers i type in to appear as if nothing is in those cells.
Then i would like to be able to type into the same cells the actaul sales
figures. However what i would like diplayed in cells A1 to A7 is the
difference between the forecast sales and the actual sales.
I would like know how this can be done without using additional cells for
either the forecast sales or the actual sales.

Excel formula?????
 

You might be able to do it with some event macros, but it would be very easy to
screw it up. I don't think anyone would ever recommend this as a solution to
this kind of problem.

Why not just use 3 columns. Column A for the difference, Column B for the
forecast and column C for the actuals.

Column A could just be a simple subtraction formula.

It sure seems lots safer to me.

David wrote:

This seems like a simple scenario although to get it to work on excel seems
impossible.

Here goes.. i would like to set up a spread sheet whereby i could type in
the various forecasts sales for the week from cells A1 to A7 say. I would
however like the numbers i type in to appear as if nothing is in those cells.
Then i would like to be able to type into the same cells the actaul sales
figures. However what i would like diplayed in cells A1 to A7 is the
difference between the forecast sales and the actual sales.
I would like know how this can be done without using additional cells for
either the forecast sales or the actual sales.

--

Dave Peterson

Excel formula?????
 

It's possible but doesn't seem to be very practical. Why would you even
think about doing it that way? You'd need to do it with VBA code. Someone
else will have to help you with that.

Biff

"David" wrote in message
...
This seems like a simple scenario although to get it to work on excel
seems
impossible.

Here goes.. i would like to set up a spread sheet whereby i could type in
the various forecasts sales for the week from cells A1 to A7 say. I would
however like the numbers i type in to appear as if nothing is in those
cells.
Then i would like to be able to type into the same cells the actaul sales
figures. However what i would like diplayed in cells A1 to A7 is the
difference between the forecast sales and the actual sales.
I would like know how this can be done without using additional cells for
either the forecast sales or the actual sales.