Hui Excel Ninja Staff member Mar 24, 2013 #2 Russell Firstly, Welcome to the Chandoo.org Forums The ^ in a formula means Raise to the power of 4^2 = 4*4 = 16 5^4 = 5*5*5*5 = 625
Russell Firstly, Welcome to the Chandoo.org Forums The ^ in a formula means Raise to the power of 4^2 = 4*4 = 16 5^4 = 5*5*5*5 = 625
V v4wade New Member Mar 24, 2013 #3 ^ is exponentiation operator. E.g: 9 ^ 2 = 9 * 9 = 81 * Try this in Excel for quick demo: 1. Enter any number in Cell A1 of an excel sheet 2. Enter '=A1^2' (without quotes) in A2 cell 3. You will get square of the number you have entered in cell A1
^ is exponentiation operator. E.g: 9 ^ 2 = 9 * 9 = 81 * Try this in Excel for quick demo: 1. Enter any number in Cell A1 of an excel sheet 2. Enter '=A1^2' (without quotes) in A2 cell 3. You will get square of the number you have entered in cell A1
