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
|