View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Srinivasulu B[_2_] Srinivasulu B[_2_] is offline
external usenet poster
 
Posts: 6
Default Antil Log Tables from Log Tables

Excellent!!!
I can't thank you enough for this Berrie...really I cant't thank you enough.
Just unbelievable!
seena


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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