Ask Your Question

How to Reciprocal Every Number in Cell of a Whole Column in Libreoffice Calc?

asked 2017-01-27 19:18:06 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to make reciprocal of a whole columns cells of libreoffice calc. I can do this by manually. Are there any way which makes reciprocal every cells element(number) of a whole column or row?

In the following figure I want to get the C column from B column:image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-28 05:33:29 +0100

robleyd gravatar image

updated 2017-01-28 05:34:54 +0100

assuming by reciprocal you mean multiplicative inverse, simply use in C1 the the formula =1/B1and drag the formula down in column C as far as you need to.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-27 19:18:06 +0100

Seen: 129 times

Last updated: Jan 28 '17