View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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