View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdsgidget cdsgidget is offline
external usenet poster
 
Posts: 9
Default Enter results in another cell

HELP!
I want my amount cell to be either a manually enter or a result of other
cells.

i.e. cell L is amount.... i want to either enter $5.00 or pickup the result
of column d ("".42) or column k&h (K7*H7)

Problem I have is that cell L has a feature to clear all contents. Can I
enter a formula in one cell and have the results input in another cell.