What it does: The IF() Function evaluates an argument. If the argument is TRUE, the formula does one thing. If the argument is FALSE, it does another thing.
Plain English: The classic logical function. If you’re cleaning a lot of data, you can use logical functions to push boolean results, ie TRUE or FALSE. Once you know whether the result is TRUE or FALSE, you can structure an IF statement around those results, allowing you do exactly what you want with the data.
“Nested” IF statements are a bit more advanced, but exactly what they sound like. If you nest IF statements, you’re essentially building multiple layers of IF statement to handle a variety of situations.
Arguments: IF(argument, result if TRUE, result if FALSE)
- Argument – What are you trying to evaluate? (must be boolean result)
- Result if TRUE – What do you want to happen if TRUE? This can be a text string, number, another formula, etc..
- Result if FALSE – What do you want to happen if FALSE? This can be a text string, number, another formula, etc..
- If this part of the formula is left blank and the argument is FALSE, the formula will return FALSE.
Pingback: Top 5 Things to Know in Excel | Every Day I'm Pivoting