Never really used Excel, so don't know what i'm doing but this > =A28/[ln(A2/0.05)/A30]+(1/20*A31*A2) equation wont work for some reason. Please help...

This part [ln(A2/0.05)/A30] is wrong, at least that's not Excel syntax

I guess ln() is natural logarithm. Question is in parentheses. Perhaps the idea was =A28/LN(A2/0.05)/A30+(1/20*A31*A2) , perhaps something else

Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

TobiasT

Copper Contributor

Nov 23, 2018

Maths formula wont work please help...

Never really used Excel, so don't know what i'm doing but this > =A28/[ln(A2/0.05)/A30]+(1/20*A31*A2) equation wont work for some reason. Please help...

Formulas and Functions

3 Replies

Mark Hamilton
Copper Contributor
Nov 23, 2018
What is "ln" in your formula?
- SergeiBaklan
  MVP
  Nov 23, 2018
  I guess ln() is natural logarithm. Question is in parentheses. Perhaps the idea was
  
  =A28/LN(A2/0.05)/A30+(1/20*A31*A2)
  
  , perhaps something else
SergeiBaklan
MVP
Nov 23, 2018
This part

[ln(A2/0.05)/A30]

is wrong, at least that's not Excel syntax