Convert excel formula into CIQ correct syntax

I have a formula in Excel:

=LN(B8/100*EXP((18.678-B6/234.5)*(B6/(257.14+B6)))))

which I have converted to CIQ-code like this:

= Math.ln(B8/100*Math.pow(2.718281828459, ((18.678-B6/234.5)*(B6/(257.14+B6)))));

They don't have the same outcome. I expect the error to be in the conversion from the EXP-function in Excel, but I cannot find it.

PS: the Excel EXP function returns the result of the constant e raised to the power of a number

jim_m_58 over 4 years ago

Try looking at it in pieces to see where the difference occur. You could be running into things like Number vs Float vs Doubles.

For example, 2.718281828459 would be used as a Float, and therefore less precision.

dpawlyk over 4 years ago in reply to jim_m_58

Ninja'd.

The standard way to do this is to break the calculation apart to see where the difference is.

You should provide the two outcomes so people know what you are talking about.

GHG23 over 4 years ago

Yes, I will do that. Thanks!

GHG23 over 4 years ago

Solved by moving the "B8/100"-part to the last part of the formula:

= Math.ln(Math.pow(2.718281828459, ((18.678-B6/234.5)*(B6/(257.14+B6))))*B8/100);