Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
power function and how it is calculated by Office Excel. | Excel Discussion (Misc queries) | |||
Excel Function to Match Power Trendline in Chart? | Excel Worksheet Functions | |||
Re : Excel Experts E-letter (No. 19) ; POWER FORMULA TECHNIQUES, Re-Visit No. 2 | Excel Programming | |||
Re : Excel Experts E-letter (No. 19, Re-Visit) ; POWER FORMULA TECHNIQUES | Excel Programming | |||
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions |