| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel what does the symbol ^ represent
Have recieved a spreadsheet with the ^ in a cell.
What does this do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel what does the symbol ^ represent
Hi,
It's the mathmatical operator meaning 'raise to the power' of: 3^3= 3 raised to the power of 3 = 27 0r 9^.5 is another way of getting the square root of 9 =3 Mike "GeorgeD" wrote: Have recieved a spreadsheet with the ^ in a cell. What does this do? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel what does the symbol ^ represent
A1^B1 means A1 raised to the power of B1
2^5 is 2 to the power 5, or 2*2*2*2*2 (=32) A1^B1 is the same as POWER(A1,B1) In some computer languages, the symbol ** is used for the same purpose as ^ is in Excel. -- David Biddulph "GeorgeD" wrote in message ... Have recieved a spreadsheet with the ^ in a cell. What does this do? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel what does the symbol ^ represent
Hi,
To raise a number to a power, use the "^" operator or the POWER function. Example A B 1. Formula Description (Result) 2. =POWER(5,2) Calculates five squared (25) 3. =5^3 Calculates five cubed (125) Challa Prabhu "GeorgeD" wrote: Have recieved a spreadsheet with the ^ in a cell. What does this do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| symbol to represent a carriage return | Excel Worksheet Functions | |||
| Are there symbols for use in Excel to represent trees and plants? | Excel Discussion (Misc queries) | |||
| WHAT DOES THE SYMBOL"$" REPRESENT IN A EXCEL FORMULA? | New Users to Excel | |||
| Represent blanks in an Excel IF statement? | Excel Discussion (Misc queries) | |||
| How to represent an empty cell in excel formulae? | Excel Worksheet Functions | |||
Hybrid Mode
