How to use a nested 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 begin another IF( function. This time, after selecting a new (or the same) range and setting new parameters for if the condition is true, open new quotations to tell the cell what to display if the condition is false. Close the quotations, add double parentheses, and press Enter. The nested IF statement allows for multiple truths, unlike a single IF statement.
For example, =IF(C3 less than symbol 15,”Under 15”,IF(C3 less then symbol 18,”15-17”,”18+”))
The example above, and in the video, is based on a list of people and their age. The nested IF function here will categorize each age into a bracket, such as “Under 15” or “18+.”
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 #ExcelNestedIf #NestedIf