function the ^ sign

D

Dav

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

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

Regards

Da
 
B

beohlsson

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
 
B

beohlsson

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
 
N

Niek Otten

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

give 0.12550881

How is E20 formatted? Format as General and look again
 
D

David Biddulph

beohlsson said:
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
Click to expand...

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.
 
B

beohlsson

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.
 
Top