Thread: Default Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StevenAFC StevenAFC is offline
external usenet poster
 
Posts: 1
Default Default Values


Is it possible to have a conditional default value, for example, if I
enter a value in one cell, it would automatically add another value.
But it would allow a person to manually override the value without
deleting the formula?

For example..

A1 B1
10 < User enters 11.75 < Excel suggests


--
StevenAFC
------------------------------------------------------------------------
StevenAFC's Profile: http://www.excelforum.com/member.php...o&userid=36471
View this thread: http://www.excelforum.com/showthread...hreadid=562365