They are simple to use and can replace C Level Contact List multiple functions that do exactly the same thing but have more complex syntaxes, which makes them less user-friendly. These two Excel formulas allow you to check if a value is an error or not before using it in your formula. They look almost identical because the first one returns TRUE if there is C Level Contact List an error while the second one display serror instead of the actual result from the calculation. This approach might seem unnecessary, but at least now you will be able to apply different actions based on the C Level Contact List results returned by these functions as well as display proper notifications about errors that might occur during your analysis.

In other words, this trick helps improve C Level Contact List data safety and helps avoid unexpected results in your reports. This function returns the relative position of an item in a range based on a matching value. This trick is useful when C Level Contact List working with databases where you have to sort records by some criteria before performing calculations. MATCH() function returns 0 if there is no match, which makes it very different from INDEX () or IF functions that return error instead. These are advanced statistical formulas used for more complex C Level Contact List analysis like distribution, percentile rank, etc.

They work almost identically C Level Contact List but differ in their syntax and purpose. You can use them together whenever necessary because they don’t cancel each other out since all of these Excel tricks operate on separate data C Level Contact List ranges. As usual, make sure you understand what result you will get before using any of these formulas in your workbook. 10. PERCENTRANK() and RANK () These Excel tricks are very similar to each C Level Contact List other, and both return percentile rank for a specified value within the range.