ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel POWER Function | What's the formula for (https://www.excelbanter.com/excel-worksheet-functions/451689-excel-power-function-%7C-whats-formula.html)

Punjabi Mathematician

Excel POWER Function | What's the formula for
 
What's the mathematical formula behind the Excel Power Function?


POWER(number, power)


How do you determine the value of (2)^(0.5) or POWER(2, 0.5)


" The Great Powers of Mathematical Functions like (0)^(-1). Divide and Rule..." A Village Idiot from Punjab

Auric__

Excel POWER Function | What's the formula for
 
Punjabi Mathematician wrote:

What's the mathematical formula behind the Excel Power Function?

POWER(number, power)

How do you determine the value of (2)^(0.5) or POWER(2, 0.5)


Are you asking how one calculates roots?

I don't know the formula Excel uses, but Rosetta Code has a page covering
this topic:

http://rosettacode.org/wiki/Nth_root

Wikipedia also has a page discussing it:

https://wikipedia.org/wiki/Nth_root_algorithm

--
Your story only tells one side.
It's based on fact, but filled with lies.

LeHuonngh2

IN BÓNG BAY IN LOGO LÊN BÓNG BAY C* SỞ IN BÓNG BAY GIÁ RẺ 0967 877 586

Cơ sở bóng bay H* Nội phục vụ mọi nhu cầu tối đa của Quý Khách trong lĩnh vực quảng cáo thiết kế bóng bay, khinh kh* cầu, cổng hơi, trang tr* cổng bóng bay, bán bóng bay bơm hydro v* in ấn các loại.

- In logo trên bóng bay; 0967 877 586

- Bán bóng bay bơm hydro ; 0967 877 586

- Bán v* bơm khinh kh* cầu 0967 877 586

- L*m v* trang tr* cổng bóng bay; 0967 877 586

- Bán cổng hơi có rồng v* không rồng các loại; 0967 877 586

- Bán que cầm bóng bay 0967 877 586

Niềm vui và sự hài lòng của Quý Khách là thành công lớn nhất của Cơ sở bóng bay H* Nội .

Mọi chi tiết xin liên hệ:

C* SỞ IN BÓNG BAY HÀ NÔI.
Hotline: 0967 877 586


https://www.youtube.com/watch?v=5YR-L2I7FT8

https://www.youtube.com/watch?v=BNu-K3YXIgE

http://indenhat.com/indenhat.html

http://indenhat.com/new/70/1023/Bao-Gia-In-Logo-Len-Bong-Bay.html

http://indenhat.com/new/70/1021/HUONG-DAN-DAT-IN-LOGO-LEN-BONG-BAY.html

http://indenhat.com/new/74/1020/GIOI-THIEU-IN-DE-NHAT.html

http://indenhat.com/new/70/1019/MAU-BONG-IN-LOGO-THUONG-HIEU.html

http://indenhat.com/new/61/1017/In-bong-bay--In-logo-len-bong-bay--Xuong-in-bong-bay.html

https://www.facebook.com/inbongbay.inlogobongbay.xuonginbongbay0967877586/

https://plus.google.com/+%C4%90%E1%BB%87Nh%E1%BA%A5tIn-chuy%C3%AAnthi%E1%BA%BFtk%E1%BA%BFin%E1%BA%A5ntr%C 3%AAnm%E1%BB%8Dich%E1%BA%A5tli%E1%BB%87u/posts/Zno8FuhDWao

https://plus.google.com/+%C4%90%E1%BB%87Nh%E1%BA%A5tIn-chuy%C3%AAnthi%E1%BA%BFtk%E1%BA%BFin%E1%BA%A5ntr%C 3%AAnm%E1%BB%8Dich%E1%BA%A5tli%E1%BB%87u/posts

Punjabi Mathematician

Quote:

Originally Posted by Auric__ (Post 1624384)
Punjabi Mathematician wrote:

What's the mathematical formula behind the Excel Power Function?

POWER(number, power)

How do you determine the value of (2)^(0.5) or POWER(2, 0.5)


Are you asking how one calculates roots?

I don't know the formula Excel uses, but Rosetta Code has a page covering
this topic:

http://rosettacode.org/wiki/Nth_root

Wikipedia also has a page discussing it:

https://wikipedia.org/wiki/Nth_root_algorithm

Newtons' Method!

Iteration!

No wonder,

"For there to exist a master race, there must exist a subservient race" - Michael Marshall

"There exist a closed form formula for just about anything out there in the UNIVERSE" - A Village Idiot from Punjab


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com