View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
raj kd raj kd is offline
external usenet poster
 
Posts: 1
Default showing formula and its value simultaneously

hi
how can 1 show a formula and its resultant value in same cell or 2
different cells?
e.g. If a1=1 & a2= 2 and my formula a3=SUM(a1:a2), i would like to
see both formula SUM(a1:a2) & its resultant value which is 3 in this
case, either in 1 cell or 2 different cells.