Thread: [Solved] How to get the inverse of the values in the same table?
View Single Post
 
Old 04-16-2011, 03:39 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 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
File Type: jpg excelClip_80.jpg (87.2 KB, 11 views)
Attached Files
File Type: xlsx Pairwise comparison matrix and relative importance weights of the evaluation criteria_02.xlsx (11.0 KB, 12 views)
Reply With Quote