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

Mark Forums Read

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,518

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:07 PM.