[Tutor] math description
alan.gauld at btinternet.com
Thu Sep 6 10:35:35 CEST 2012
On 29/08/12 21:20, damjan kuzmic wrote:
> i would like to know how to write a formula that in excell looks like this:
> A / EXP(-LN(2) * t)
Start by breaking it down from the inside out.
LN(2) is log(2) in Python, which is found in the math module so you need
import math too.
negation ( -LN() ) and multiplication are builtin (* t)
EXP() is exp(), also in the math module.
division is built in (although I'm not sure if Excel / is integer
or 'real' division, given the nature of the values I'll assume its real...
So the final expression should look like
value = A/math.exp(-math.log(2) * t)
Which isn't too different to Excel.
Author of the Learn to Program web site
More information about the Tutor