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, 04:59 AM

macropod

Windows 7 32bit How to get the inverse of the values in the same table?

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

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]

« 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 12:30 PM.