![]() |
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 |
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. |
Quote:
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