Thread: Unknown Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Unknown Formula

The caret (^) indicates that the following number is an exponent.

^0.5 = ^1/2 = Square Root

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Lucky_guy2000" wrote:

I am working on correcting links and formulas on an inherited worksheet and
came across the following formula:

=35*B3*(B11+3000)^0.5

I do not understand the purpose of ^0.5. Can anyone help?

Thanks.
Johnnie