simple excel formula question

EH75 · 7 Nov 2006 at 21:05

Having not used excel for about 3 years I've kinda forgot how to work it. Anyway i've got some data aready input and would like to set up a formula to calculate 10^-C2 10^-C3 etc. So basically I have quite a few values in the C column, i would like excel to convert them to negitive and then find out what 10 to the power of this negitive value wound be, then put it the designated cell. Have mucked about with a few combinations but nothing seems to work. Any help would be great.

Cheers

rich_g85 · 7 Nov 2006 at 21:40

=10^(-C3)

I think...

EH75 · 7 Nov 2006 at 21:45

nah that was what i thought it would be aswell, it doesn't work. wondering wether it uses a different sign from ^ to denote power to or something...everything comes out as 0.00 when i use that formula, got all the cells set up as numbers to 2 decimal places, don't need to change something so it will display negitive numbers do i?

rich_g85 · 7 Nov 2006 at 21:48

Try this:
=POWER(-C1, 10)

Raises the first argument to the power of the second argument.

EH75 · 7 Nov 2006 at 21:55

cheers, that sorted it...well it was =POWER(10, -C2) but that was what I was after thanks

rich_g85 · 7 Nov 2006 at 21:56

Great stuff - glad I could help. I learnt something too