View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pnorgate pnorgate is offline
external usenet poster
 
Posts: 1
Default Show values in formula instead of cell reference


Thanks for that however it is still not quite what I am looking to
achieve.
Imagine a table with rows and columns like in a scool book but instead
of just showing the answer as below I want to show the formula as
values - see second table below what I mean.


Table 1
+ 1 2 3
1 2 3 4
2 3 4 5
3 4 5 6


Table 2
+ 1 2 3
1 1+1=2 1+2=3 1+3=4
2 2+1=3 2+2=4 2+3=5
3 3+1=4 3+2=5 3+3=6


Can anyone help please?

Cheers,

Pasha


--
pnorgate
------------------------------------------------------------------------
pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753
View this thread: http://www.excelforum.com/showthread...hreadid=573365