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:
To make it exactly as shown in the image, put this in cell C1:
="1/" & B1
Then fill down by dragging the lower right hand corner of the cell down to row 12.
To calculate the reciprocal, put this in cell C1 instead:
=1/B1