Search results
Results from the WOW.Com Content Network
You may not post new threads; You may not post replies; You may not post attachments; You may not edit your posts
Join Date 01-25-2005 Location Lancashire, England MS-Off Ver MS Office 2000, 2003, 2007 & 2016 365 Posts 4,867
is it to take the square root of 25 = 5 and then do 5 x 5 x 5 x 5 or is it square root of 5 = 2.23606797749979 square root of 2.23606797749979 = 1.495348781221221 square root of 1.495348781221221 = 1.222844544993852 ie should the answer be 625 or 1.222844544993852? or something else entirely?
Join Date 12-23-2009 Location Fife, Scotland MS-Off Ver Excel '97 & 2003/7 Posts 7,216
The formula you have is missing a parentheses somewhere -- there are 2 opening parentheses "(" and 3 closing parentheses ")". I am surprised you can use this formula exactly as it reads with the missing parenthesis -- unless you blindly accepted Excel's correction which could have easily put the missing parenthesis in the wrong place.
Greetins everyone, hoping I can get some insight. Not sure if this is even possible. I have a field in an excel sheet that shows the dimensions in a room. 12'5"x10'6" Considering both the width and height are all in one field, is there anyway to get excel to calculate the above in square feet? Basically multiply all the numbers in that 1 field.
The brackets indicate an Array Formula. It changes how Excel handles the calculations. To enter an array formula, use the key combination CTRL-SHIFT-ENTER rather than just Enter. HTH, Elkar "BedeviledByBrackets" wrote: > What do { } brackets mean when they encompass a function? > > The following function, which works when the spreadsheet is ...
If it is a text entry, as in "16 square feet", enter "162 feet", then in the formula bar, highlight the '2' and choose Format>Cells from the main menu. On the Font tab, tick the 'superscript' option and click OK. The result will be "16-2- feet" with the -2- as the small, raised squared sign. Of course both of these apply to any power as well. HTH
cell a1 = 9 what would the formula be to get the cubed root of the value in cell a1 ? i found the square root formula "=SQRT(a1) but nothing hs worked yet for cubed root thanks Register To Reply 05-21-2006, 08:15 PM #2
I simply entered 0.02 from Cells N2 thru N1450 and the formula correctly returned 0.02 whereas geomean gave 0 "Dan Knight" <[email protected]> wrote in message news:[email protected]... > We have workbook that uses the GEOMEAN function on a column of data. The > values being analyzed are returned by the formula =IF(M1=0," ",M1) to > ensure