ExcelBanter - Inverse ... Formula or Function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Inverse ... Formula or Function? (https://www.excelbanter.com/excel-discussion-misc-queries/200737-inverse-formula-function.html)

Ken

Inverse ... Formula or Function?

Excel2003 ... I have a Col of decimal numbers formatted (.000)

I wish to calculate the "inverse" decimal values for these numbers.

What is the formula or function to do this?

Thanks ... Kha

Elisabeth D

Inverse ... Formula or Function?

=1/A1 where A1 contains your decimal figure.

"Ken" wrote:

Excel2003 ... I have a Col of decimal numbers formatted (.000)

I wish to calculate the "inverse" decimal values for these numbers.

What is the formula or function to do this?

Thanks ... Kha

All times are GMT +1. The time now is 03:38 PM.