Search code examples
functionlibreoffice-calcinverse

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


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:

enter image description here


Solution

  • 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