P
Pé
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 !!!!
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 !!!!