software

How do I get this to work with excel

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

Tia
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: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=508872=(1.03)^4-1

Format as percentage

--
Kind regards,

Niek Otten

quot;beohlssonquot; gt; wrote in message ups.com...
gt; How do I get this to work with excel
gt;
gt; 1,03 ^ 4 - 1 = 0,1255 = 13%
gt;
gt; Tia
gt;
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
appreciatedIt is the exponentiation operator, raising a number to a power.

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

--
Kind regards,

Niek Otten

quot;beohlssonquot; gt; wrote in message ups.com...
gt;I found another way
gt;
gt; =SUM(B18^C18)-D18
gt;
gt; What's the english name of the ^ sign, please
gt;
gt; Thanks a lot for your answer and time spent on my problem highly
gt; appreciated
gt;
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 plsBoth =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

quot;beohlssonquot; gt; wrote in message oups.com...
gt; Ok! Still can't get it
gt;
gt; B18 = 1.03 (or 1,03)
gt; C18 = 4
gt; D18 = 1
gt; E20 =SUM(B18^C18)-D18 = 0,00%
gt;
gt; On my calculator the answer is 0,1255 or 13%. The numbers seems to be
gt; too small somehow for excel ;-)
gt;
gt; Help pls
gt;
quot;beohlssonquot; gt; wrote in message oups.com...
gt; Ok! Still can't get it
gt;
gt; B18 = 1.03 (or 1,03)
gt; C18 = 4
gt; D18 = 1
gt; E20 =SUM(B18^C18)-D18 = 0,00%
gt;
gt; On my calculator the answer is 0,1255 or 13%. The numbers seems to be
gt; too small somehow for excel ;-)
gt;
gt; 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
Problem solved ;-) Started over again.

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

Thanks a lot.