Forum Discussion

TobiasT's avatar
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

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      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's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 23, 2018

    This part

    [ln(A2/0.05)/A30]

    is wrong, at least that's not Excel syntax

     

Resources