Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
Can anyone tell me what funtion the ^ character performs in a formula?
Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
Mickford wrote:
Can anyone tell me what funtion the ^ character performs in a formula? Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) Raise to a power (in this case, I think 4 root) Beege |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
Can anyone tell me what funtion the ^ character performs in a formula?
Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) It is how you raise one number to a power. Put this in a cell and it should become clearer to you... =2^3 Two raised to the third power is 8. Rick |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
I believe it means 'to the power of'
ie 3^3 = 27 -- Traa Dy Liooar Jock "Mickford" wrote: Can anyone tell me what funtion the ^ character performs in a formula? Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
The '^' character means "raise a number to a power". For example,
3^2 = 3 * 3 = 9 2^3 = 2 * 2 * 2 = 8 For roots of a number, such as the square or cube root, you use (1/N) where N is the root you want to return. For example, 9 ^ (1/2) = 3 8 ^ (1/3) = 2 16 ^ (1/4) = 2 In the formula you posted, the sub-part (F6/B6)^(1/4) divides F6 by B6 and then takes the 4th root of that quotient. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Mickford" wrote in message ... Can anyone tell me what funtion the ^ character performs in a formula? Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ do in a formula?
It's the exponentiation operator.
In that formula, it raises (F6/B6 to the one-fourth power (or, equivalently, returns the fourth root of F6/B6). Note that the + is unnecessary in the formula. In article , Mickford wrote: Can anyone tell me what funtion the ^ character performs in a formula? Example: IF(OR(B6<=0,F6<=0),"--",((+F6/B6)^(1/4)-1)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|