ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using formula to calculate a number. (https://www.excelbanter.com/excel-worksheet-functions/14302-using-formula-calculate-number.html)

VTM

Using formula to calculate a number.
 
How do a write the formula or function to satisfy: Y to the x power. In the
equation Y= 2 and x power = 3 the answer would be 8.

Ken Wright

=2^3

or

=POWER(2,3)

or substitute cell references for the numbers.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"VTM" wrote in message
...
How do a write the formula or function to satisfy: Y to the x power. In

the
equation Y= 2 and x power = 3 the answer would be 8.




Steve


=A1^B1

"VTM" wrote in message
...
How do a write the formula or function to satisfy: Y to the x power. In
the
equation Y= 2 and x power = 3 the answer would be 8.





All times are GMT +1. The time now is 01:03 AM.

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