View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
a94andwi[_27_] a94andwi[_27_] is offline
external usenet poster
 
Posts: 1
Default Default value in empty cell


Maybe I need to explain myself a little to make you understand.

I have a sheet that contains default value in cell A1.
This value is out of my system at work and I am trying to tweak th
system and need to try out new values to see what the output will be.

In cell B1 I have the "test cell". This is where I do the tweak inpu
values.

In cell C1 I have calculations that take the new values in B1 and giv
me an idea of what my system will create for values when put thes
values into the system.
I do not want to put the figures into the system before I know that i
will not create a disaster. I'm working at an international company an
wrong inputs may cause a lot of damage and cost a lot of money.

I am trying to see what can happen before I actually do it.

This is why I would like the cells B1 to contain the same value as i
cell A1 until I write something in cells B1. If the result is not wha
I would like it to be I erase the input in cell B1 and it show th
default value taken from cell A1.

It would be great if this is possible to do to create huge tes
environments.

/Ander

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=53924