function the ^ sign
 

How do I get this to work with excel

1,03 ^ 4 - 1 = 0,1255 = 13%

Tia

function the ^ sign
 

Depending on your seperator settings (where you are in the world)

=1.03^4-1 gives your required result, just format the cell as a
percentage (format,cells,number,percentage 0dp) to get the result

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=508872

function the ^ sign
 

=(1.03)^4-1

Format as percentage

--
Kind regards,

Niek Otten

"beohlsson" wrote in message
ups.com...
How do I get this to work with excel

1,03 ^ 4 - 1 = 0,1255 = 13%

Tia

function the ^ sign
 

I found another way

=SUM(B18^C18)-D18

What's the english name of the ^ sign, please

Thanks a lot for your answer and time spent on my problem highly
appreciated

function the ^ sign
 

It is the exponentiation operator, raising a number to a power.

Pete

function the ^ sign
 

Just leave out SUM. Not needed. The symbol is called caret.

--
Kind regards,

Niek Otten

"beohlsson" wrote in message
ups.com...
I found another way

=SUM(B18^C18)-D18

What's the english name of the ^ sign, please

Thanks a lot for your answer and time spent on my problem highly
appreciated

function the ^ sign
 

Ok! Still can't get it

B18 = 1.03 (or 1,03)
C18 = 4
D18 = 1
E20 =SUM(B18^C18)-D18 = 0,00%

On my calculator the answer is 0,1255 or 13%. The numbers seems to be
too small somehow for excel ;-)

Help pls

function the ^ sign
 

Both =SUM(B18^C18)-D18 and =(B18^C18)-D18

give 0.12550881

How is E20 formatted? Format as General and look again

--
Kind regards,

Niek Otten

"beohlsson" wrote in message
oups.com...
Ok! Still can't get it

B18 = 1.03 (or 1,03)
C18 = 4
D18 = 1
E20 =SUM(B18^C18)-D18 = 0,00%

On my calculator the answer is 0,1255 or 13%. The numbers seems to be
too small somehow for excel ;-)

Help pls

function the ^ sign
 

"beohlsson" wrote in message
oups.com...
Ok! Still can't get it

B18 = 1.03 (or 1,03)
C18 = 4
D18 = 1
E20 =SUM(B18^C18)-D18 = 0,00%

On my calculator the answer is 0,1255 or 13%. The numbers seems to be
too small somehow for excel ;-)

Help pls

It comes to 0.125509 for me.
I assume that you've got at least one of the cells formatted as text, and
therefore treated as zero. You need to be careful with your settings as to
whether it is regarding a full stop or a comma as a decimal point.
--
David Biddulph

function the ^ sign
 

Problem solved ;-) Started over again.

Had some strange formatting in different cells? Now cell B18,C18&D18 as
general and E20 as percentage = 13%

Thanks a lot.

function the ^ sign
 

E20 =SUM(B18^C18)-D18 = 0,00%

Another option:
=POWER(1.03,4)-1

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"beohlsson" wrote in message
oups.com...
Ok! Still can't get it

B18 = 1.03 (or 1,03)
C18 = 4
D18 = 1
E20 =SUM(B18^C18)-D18 = 0,00%

On my calculator the answer is 0,1255 or 13%. The numbers seems to be
too small somehow for excel ;-)

Help pls