how to raise a number in excel?

Answer this question

  • how to raise a number in excel?


Answer #1 | 28/12 2013 21:45
Answer #2 | 28/12 2013 22:22
The two methods of raising a number to a power are the POWER function, as previously offered, or using the 'caret' symbol: =A1^3 This will cube the value contained in cell A3. It is not necessary to apply the superscript to the power indicator. Similarly if the power indicator is a negative number, the result will be 1 divided by the number raised to the power indicated. Thus, 10^-3 would result in 1/1000, or .001.
Answer #3 | 28/12 2013 22:48
There is no Super/Sub-script shortcut in Excel like there is in Word. You have to manually edit the Font options to switch back and forth. Press CTRL+Shift+F to bring up Font options, select Superscript, then type what you need to type. After you are doing, turn off Superscript using the aforementioned method.
Answer #4 | 28/12 2013 23:15
You will have to use the Font tab in Format Cells to mark the 3 as superscript. The cell also has to be formatted as Text, or Excel will simply interpret the superscript as a regular number and turn it back to normal size. In the case of superscript 3, there is also a ³ symbol you can add, available in most fonts. Keep in mind that Excel will not actually treat ³ as a numeric exponent—it just sees it as another text character, and will cause the entire value to be treated as text. There is no shortcut, nor any command that you could add via the Quick Access toolbar, except through VBA. In order to *calculate* an exponent, you can use the POWER() function or the ^ operator.

Possible answer