View Single Post
 
Old 04-16-2011, 05:53 AM
Jamal NUMAN Jamal NUMAN is offline Windows XP Office 2007
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Thank you Paul.

but that formula does not give the result i'm looking for.

please, see the attached table. how could i involve (1/OFFSET($C$3,COLUMN()-3,ROW()-3)) into the table? i tried but it didn't give the same result!!!

regards

Jamal
Quote:
Originally Posted by macropod View Post
Hi Jamal,

In any of the cells, try: =1/OFFSET($C$3,COLUMN()-3,ROW()-3)
Copy across and down as needed. You can format the cells as fractions (up to 2 digits) if you want to see the results as fractions.

Last edited by macropod; 04-16-2011 at 06:10 AM. Reason: Half-page of white space deleted
Reply With Quote