Excel formula?????

[Guest]

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]

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.

 

[Biff]

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

 

[Niek Otten]

<without using additional cells>

Do use additional cells. You can hide those you don't want to show.
Any other solution would be far more complicated and possibly get you into trouble some time.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.