View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darren Darren is offline
external usenet poster
 
Posts: 137
Default assigning values to one cell which will change the formula in anot

Does anyone know if it is possible to assign a value to a number, say 1, that
when entered into a cell it will automatically change the formula in
corresponding cells. EG. If 1 = +10days
I enter 1 in b3, then the formual in b5 will change from +20days, to +10days
etc.

I don't even know if this is possible with excel, but would very much
appreciate any feedback possible. Thanks.