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

		Microsoft Office Forums > Microsoft Excel > Excel
How to get the inverse of the values in the same table?

FAQ

Thread Tools

Display Modes

04-16-2011, 03:39 AM

Jamal NUMAN Jamal NUMAN is offline

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

Office 2007

Expert

Join Date: Nov 2010

Posts: 615

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

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

Attached Images

excelClip_80.jpg (87.2 KB, 11 views)

Attached Files

Pairwise comparison matrix and relative importance weights of the evaluation criteria_02.xlsx (11.0 KB, 12 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.