In cell A2, enter the formula
=(ROW()-ROW($A$2))/1000 + INT((COLUMN()-COLUMN($A$2) +1)/2)*0.1

Then in B2, enter the formula
=10^A2

Copy A2:B2, and paste in A3:B101.

Then copy A:B, and paste in C:T

Then copy everything, and paste special values over the formulas, and you have your table of values.

HTH,
Bernie
MS Excel MVP


"Srinivasulu B" wrote in message
...
For my children I wanted to have practice in using log table while multiplying and dividing.
For this I have a book Clark's Tables (Science Data Book) by Orient Longmans
This has Log and Anti Log tables.
This is what I have been using in my school days.
Now this book is not easily available.
I wanted to take a hard copy of the these Log and anti log tables.
But I was not successful...as the paper is quite soiled.
Then I made search on the net.
I got a link.
http://www.sosmath.com/tables/logtable/logtable.html
Here I have log tables.
I also would like to have Antilog tables also...which is not available in this site.
How can I generate Anti Log table using this table.
Any help?
seena