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 ...
Formulas and Functions
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