There are many ways to perform linear interpolation (or extrapolation) in Excel.
Showing posts with label Math. Show all posts
Showing posts with label Math. Show all posts
Factorial of Positive Non-Integer Values in Excel
I'm in the proces of creating a control chart template and needed to calculate the factorial of a non-integer value in Excel.
Warning: Excel Performs Negation Before Exponentiation
What does –5² equal? –25 or 25? If you said –25, then you probably listened in school when you were told that negation should be performed on the same level as subtraction, which comes after exponentiation, so –5²=-(5²)=–25.
Rounding Significant Figures in Excel
Use the following formula to round a value to a certain number of sigfigs:
=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))
Subscribe to:
Posts (Atom)