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.