| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exponents in excel
Just use the Format - Cell - Number - Scientific
"Pé" wrote: I am trying to have excel calculate the exponent automatically. I already found out this can be done by using the ^ sign, but the amount of data is to large to do this individually for each cell. How can I have in the rows numbers from 1 till 1000 (cells a2 till a1001), and then in my row headers values from 1 till 10 (cells b2 till b11). Now I would like excel to calculate each time the exponent for cell a2 & b2 ; a3 & b2 ; a4 & b2 ... ; next collumn a2 & b3 ; a4 & b3 ...) Is there a formula that exists in excel? Thanks for your help !!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Superscripted exponents | Excel Discussion (Misc queries) | |||
| How can you format so you could write x squared using exponents? | Excel Discussion (Misc queries) | |||
| I wish to display numbers in engineering format (exponents * 3). | Excel Discussion (Misc queries) | |||
| sum of a series of exponents | Excel Worksheet Functions | |||
Hybrid Mode
