View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mjahanbin@gmail.com is offline
external usenet poster
 
Posts: 2
Default set second cell value based on formula in first cell?

(G8,0) is not a valid excel formula, but it is a valid string.

Worksheet functions can only return values. The returned value is
displayed in the cell containing the formula. Formulas can not direcly
effect the value of other cells but they can be refered to by those
cells.

In order to give an answer you can use you really need to explain the
problem some more.

/m

http://www.aminaahamed.com