close

I was sent a spreadsheet that is supposed to calculate interest earned. It
has a character in the middle of the formula that I have not seen before.
What does ^ do in the formula?

Caret: quot;^quot; means quot;to the power ofquot;
(the exponentiation operator)

Eg: entering in say, A1: =2^4
means to evaluate 2 to the power of 4
i.e: =2 x 2 x 2 x 2 =16
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;frustrated financial personquot; omgt; wrote in message
...
gt; I was sent a spreadsheet that is supposed to calculate interest earned.
It
gt; has a character in the middle of the formula that I have not seen before.
gt; What does ^ do in the formula?
The quot;^quot; is the exponentiation function.

In this formula =B8*(1 $C$1)^(($C$3-$C$2)/365)-B8, it raises (1 $C$1) to
the power of (($C$3-$C$2)/365).

quot;frustrated financial personquot; wrote:

gt; I was sent a spreadsheet that is supposed to calculate interest earned. It
gt; has a character in the middle of the formula that I have not seen before.
gt; What does ^ do in the formula?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()