IF Formula in Excel
How to Use the IF Formula in Excel The IF function is used to make a logical comparison between two values either within a formula or by comparison of the values/arguments of two cells. The IF function then determines whether the argument is TRUE or FALSE. Formula...
ABSOLUTE Formula in Excel
How to Use the ABSOLUTE Formula in Excel The ABSOLUTE formula in Excel returns the absolute value of a number. The absolute value of a number is the number without its positive or negative integer signs. This can be useful when you are working with debits and credits...
MIN, MAX, MEDIAN Formula in Excel
How to Use the MIN, MAX, MEDIAN Formula in Excel You can use MIN and MAX formula to determine the smallest and largest values in a field based on the specified aggregation or grouping. The MEDIAN is the number in the middle of a set of numbers. This is a very simple...
TEXTJOIN Formula in Excel
How to Use the TEXTJOIN Formula in Excel Concatenating cells together using a delimiter to separate them. This is especially more efficient to use versus a manual method of concatenating cells together if you are working with a large data set and just need to...
