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
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.
|