Forum Discussion

My-atix's avatar
My-atix
Copper Contributor
Jun 25, 2023

How to convert formula to excel?

 

Hi All,

 

I have been struggling to convert the below formula into an excel formula.

 

Can someone tell me how it is written?

 

 LN = 10 + 50 log (10) + 10 log (0.0314)

 LN = 45

 

I hope someone can help?

 

Thanks!

 

Formulas and Functions

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 25, 2023

    My-atix 

    It looks like exercise to receive result without calculator. The only which method to use, for each we shall to memorise some basic values.

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 25, 2023

    Hi My-atix 

     

     

    =10 + 50 * LOG(10) + 10 * LOG(0.0314)

     

    Result: 44.96929648

     

    If you want 45 instead:

    =ROUND(10 + 50 * LOG(10) + 10 * LOG(0.0314), 0)

    EDIT: or Format Cells > Number > Number > Decimal places: 0

     

     

Resources