Error Message:
Your formula should reference the cell containing field label. Please make sure the value LN10 is referencing the correct cells.

My thought:
Looks like LN10 was recognized as a reference to a cell rather than formula.

Below is how I apply the formula

Are there hidden rules to apply formula under Math.*?
Please share with me how you apply formula under Math.*, especially LN10.

Thanks,
Jonah

UPDATE
I just realize I could use Math.log(A16) to get the natural log of A16. Therefore, my issue is solved for now. But I still think that this page is not easy to understand.

Hi,
based on the page.
Math.LN10 itself will return a value for you.
However, when I tried this in the formula, it didn’t work.

So I tried using Javascript to see if it’s able to calculate it. And it works.
However, I still wanna try using the existing Ragic formula to see if there’s anyway to get the same value.
Turns out that Math.log(x) (for natural logarithm) does work. However, since that Math.LN10 doesn’t work properly when I use it in the formula and I have long forgotten about logarithm math, so I enlisted ChatGPT for some enlightment.
And I was able to find that you can get Log10 value without using Log10 function specifically.

You can try using this formula:
Math.log(x)/Math.log(10)

Note: be aware of the caption in the formula. I accidentally used Math.Log(x) with a Cap L and it doen’t work.