First time here? Check out the FAQ!
I can't believe I have to ask this question. I've been all over the Help section. I find how to use a formula for SQRT, but nothing that tells me how to square a number or term in a formula. I tried the Microsoft equivalent (**)and got an error message. I then looked in the list of operators and in the formula section and found nothing.
You have to enter in the cell: "=x^2" ( without the "). You can replace the 2 with any number, e.g. X^0.5 equal SQRT(X). Have fun!!
Can't you just multiply it by itself? That's the definition of "squaring". x * x. Is that not what you're trying to do?
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-04 18:26:54 +0200
Seen: 215 times
Last updated: Sep 04 '12
To display two cells contents together in another cell
Writer and Calc: insert-object-formula?
Displaying formulas from horizontal block of cells to vertical block of cells
How to create an XY plot with individual data points?
Date format don't work after upgrade to 3.6 from 3.5
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.