How to get the inverse of the values in the same table?

macropod · #1 04-16-2011, 04:59 AM

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.

Jamal NUMAN · #2 04-16-2011, 05:53 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
comparing values from a range	struct	Excel	1	04-01-2011 07:17 PM
Calendar control accepts other values	JeJ	Word	0	03-02-2011 03:38 PM
help with formulate refers to values	meninio	Excel	11	01-26-2011 10:00 AM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM
Opening .pst with dummy values	ran_sushmi	Outlook	0	08-19-2009 01:56 AM