Is there a way to calculate "20^4" in numbers?
I get a syntax error when I type in =20ˆ4 .
I know it can be calculated using power(20,4), but I would like an alternative.
Thanks in advance.
MacBook Pro 13″, macOS 10.15
I suspect you are typing an extra = sign.
Select the cell in which you want to do the calculation.
Type an = to open the formula editor.
Type the formula 20^4 in the editor.
Click the gren checkmak to confirm the formula and close the editor.
Your result will be shown in the cell.
The formula will be shown in the box at the left, and below the document window:
Regards,
Barry
PS: having read Badunit's reply and taken another look at your post and at what is displayed in the box in the mage above, I can see where numbers may have misled you as to the character to type for the 'to the power of' sign'.
Shift - 6, not option - i.
B.
Is this the problem: 20^4 versus the 20ˆ4 I see in your post? The first one is correct and uses the carat, the character above the number 6. The second is incorrect and has the character generated by pressing Option and i at the same time.
It's working fine here:
=20^4
What syntax error are you getting (click the warning triangle).
SG
Calculate exponents in numbers (on Mac)
