The IF statements in Microsoft Excel are simple, but powerful.
Below are 4 IF statements in Excel I use every day:
Below are 4 IF statements in Excel I use every day:
1. IF
=IF(logical test, value if true, value if false)
- use to capture a certain variable
- use to confirm greater or less than
- can combine with other formulas
=IF(C4>0,VLOOKUP(C4,table!A:G,5,false),"negative")
=IF(logical test, value if true, value if false)
- use to capture a certain variable
- use to confirm greater or less than
- can combine with other formulas
=IF(C4>0,VLOOKUP(C4,table!A:G,5,false),"negative")
2. SUMIF
=SUMIF(range, criteria, sum range)
- use to sum totals by categories
- quickly only sum what is appropriate
=SUMIF(range, criteria, sum range)
- use to sum totals by categories
- quickly only sum what is appropriate
3. IFERROR
=IFERROR(value, value if error)
- use to detect errors in formulas
- quickly identify missing data
=IFERROR(VLOOKUP(C4,table!A:G,5,false),0)
=IFERROR(value, value if error)
- use to detect errors in formulas
- quickly identify missing data
=IFERROR(VLOOKUP(C4,table!A:G,5,false),0)
4. IFS
=IFS(logical test 1, value if true1, logical test 2, value if true2...)
- use if there are multiple options
- use to identify & categorize
- use to standardize data
=IFS(logical test 1, value if true1, logical test 2, value if true2...)
- use if there are multiple options
- use to identify & categorize
- use to standardize data
TL; DR;
4 Amazing IF statements in Excel
1. IF
2. SUMIF
3. IFERROR
4. IFS
4 Amazing IF statements in Excel
1. IF
2. SUMIF
3. IFERROR
4. IFS
If you enjoyed this thread:
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
To see these 4 IF statements in Excel, check out this video:
youtu.be
youtu.be
Loading suggestions...