
Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
Thanks for that however it is still not quite what I am looking t
achieve.
Imagine a table with rows and columns like in a scool book but instea
of just showing the answer as below I want to show the formula a
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,
Pash
Mike - 20 Aug 2006 09:15 GMT
This does the trick
=TEXT(B1,"#")&" + "& TEXT(A2,"#")&" = "&B1+A2
Mike
> Thanks for that however it is still not quite what I am looking to
> achieve.
[quoted text clipped - 25 lines]
> pnorgate's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37753
> View this thread: http://www.excelforum.com/showthread.php?threadid=573365
pnorgate - 20 Aug 2006 09:31 GMT
Perfect!!!
Many many thx to all that contributed and I hope it will prove helpfu
to anyone else stuck on "school work".:eek:
Pash