![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
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 Last edited by macropod; 04-16-2011 at 06:10 AM. Reason: Half-page of white space deleted |
#4
|
||||
|
||||
![]()
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
appreciated Paul. it did work
regards Jamal Quote:
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
struct | Excel | 1 | 04-01-2011 07:17 PM |
Calendar control accepts other values | JeJ | Word | 0 | 03-02-2011 03:38 PM |
![]() |
meninio | Excel | 11 | 01-26-2011 10:00 AM |
![]() |
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
Opening .pst with dummy values | ran_sushmi | Outlook | 0 | 08-19-2009 01:56 AM |