How to use an IF statement in Excel to categorize cell values
How to use multiple IF statements in the same function to categorize cell values. First, select the first cell you want to categorize. Then type =IF( and select the range, or single cell, to which you want to apply your logic. Next to the cell range, add your logic, or condition. Add a comma and open quotations to tell the cell what to display if the condition is true. Close the quotations, add another comma, then open new quotations to tell the cell what to display if the condition is false. Close the quotations and parentheses, and press Enter.
For example, =IF(C3 less than symbol 15,”Over 15”,”15 or Under”)
The example above, and in the video, is based on a list of people and their age. The IF function here will categorize each age into a bracket based on a single true/false statement.
Best uses include: Categorizing or bucketing ranges of data.
Website: www.trendlineanalysis.com
More Excel videos: • How To: Excel Tips and Tricks
Subscribe: / @trendlineanalysis
#Excel #ExcelIf #IfStatement