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

Jamal NUMAN · #1 04-16-2011, 03:39 AM

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

Please, see the attached image that shows my question. (The excel file is also attached)

The values in the table are separated by the diagonal. The lower part is the data, the upper are the calculated. They represent the inverse of the lower values…how to program the equation in the upper cells to get this result?

Should we program them cell by cell to get this result??????

Thank you

macropod · #2 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 · #3 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.

macropod · #4 04-16-2011, 06:09 AM

Hi Jamal,

That is not the same spreadsheet that was attached to your other post. Neither does it have the formula I posted in it.

Naturally, since the layout is different, it would be unreasonable to expect a formula designed for a different layout to work with this one. If you delete Column A from the second workbook you posted, then the formula I gave you will work.

Jamal NUMAN · #5 04-16-2011, 06:24 AM

appreciated Paul. it did work

regards

Jamal

Quote:

Originally Posted by macropod

Hi Jamal,

That is not the same spreadsheet that was attached to your other post. Neither does it have the formula I posted in it.

Naturally, since the layout is different, it would be unreasonable to expect a formula designed for a different layout to work with this one. If you delete Column A from the second workbook you posted, then the formula I gave you will work.

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