# Using Exponents in Formulas

Problem

You need to write a formula that raises some number to some power but you don't know the syntax for exponentiation in Excel.

Solution

Use the caret (^) operator.

Discussion

Raising a number to some power is a common calculation task. In Excel, the caret operator (^) is used for exponentiation. For example, to raise the number contained in cell A1 to the third power, you could enter the formula =A1^3. You can use whole number exponents as well as decimal numbers or even other operations. For example, the formulas =A1^0.25 and =A1^(1/4) both raise the value in cell A1 to the one-fourth power.

You need not hardcode exponents. You could use a number contained in another cell as an exponent; e.g., =A1^C5, or =A1^(C5+D10), or =(A1+A2)^(C5/E8), and so on.

See Also

See Recipe 1.10 for other common mathematical functions . Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Similar book on Amazon

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net
{"ft_lang_label":"__label__en","ft_lang_prob":0.83411634,"math_prob":0.9216682,"size":1260,"snap":"2021-04-2021-17","text_gpt3_token_len":304,"char_repetition_ratio":0.11863057,"word_repetition_ratio":0.010638298,"special_character_ratio":0.21428572,"punctuation_ratio":0.10176991,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99812853,"pos_list":[0,1,2,3,4],"im_url_duplicate_count":[null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-04-20T14:08:38Z\",\"WARC-Record-ID\":\"<urn:uuid:6eabcf6d-98ba-42cc-bab8-c707cf3122d3>\",\"Content-Length\":\"36985\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:5fe546ae-1b2a-44ee-ae0d-dbff5056a169>\",\"WARC-Concurrent-To\":\"<urn:uuid:d4d5c78f-faa3-4532-8782-c602f80a246b>\",\"WARC-IP-Address\":\"179.43.157.53\",\"WARC-Target-URI\":\"https://flylib.com/books/en/2.22.1/using_exponents_in_formulas.html\",\"WARC-Payload-Digest\":\"sha1:OIITSKMETB6OOYR72DTI3HOOW3LY4RSY\",\"WARC-Block-Digest\":\"sha1:GNRQZOWTTQRVZEV6NKINCLQAFSJ4Q54H\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-17/CC-MAIN-2021-17_segments_1618039398307.76_warc_CC-MAIN-20210420122023-20210420152023-00273.warc.gz\"}"}