View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haydie-lady[_2_] Haydie-lady[_2_] is offline
external usenet poster
 
Posts: 7
Default Show the formula not the result

Is there a way to have a cell show the formula not the result? More
specifically show the formula with the values of the cells used to calculate
the result not the cell referenced. I want the cell next to my result(10) to
show the formula used to get my result, =5*2 OR =Height*Length NOT =B2*B3
EXAMPLE:

GIVEN
Height 5
Length 2
CALCULATED
Area 10