View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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