Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634

Опубликовано: 22 Январь 2020
на канале: excelisfun

17,637

773

Download Excel File: https://excelisfun.net/files/EMT1634....
12 IF Function examples to make you an IF Function Pro. Learn these topics:
1. (00:01) Introduction.
2. (00:52) What IF Function does?
3. (01:17) Logical Formula.
4. (01:51) Comparative Operators.
5. (03:42) Payroll Bonus Formula. Description of three arguments in IF Function. See how to put 1 of 2 numbers into a cell.
6. (04:55) Data Usage Formula. See how to put 1 of 2 test items into a cell.
7. (06:00) Commission Formula. See how to put 1 of 2 numbers into a formula.
8. (07:15) Don’t get tricked by Number Formatting.
9. (07:47) Payroll Overtime Formula.
10. (08:31) Income Statement Formula.
11. (09:12) OR Function with IF Function.
12. (10:37) AND Function with IF Function.
13. (11:40) Nested IF Functions to put 1 of 3 things into a cell. Social Security Hurdle Formula.
14. (13:21) Bad Use for IF Function. When not to use IF function, but Lookup Function instead.
15. (13:50) IF Function Array Formula. Standard Deviation Formula.
16. (15:26) IS Functions in IF Function. Account Balance Formula.
17. (16:50) Summary and End Video Links.