๐๐๐๐๐๐ ๐๐ก๐ ๐๐ ๐ ๐จ๐ซ๐ฆ๐ฎ๐ฅ๐ ๐ข๐ง ๐๐ฑ๐๐๐ฅ (๐๐๐ ๐ข๐ง๐ง๐๐ซ ๐ญ๐จ ๐๐ซ๐จ)
ะฝะฐ ะบะฐะฝะฐะปะต: ๐๐๐๐ข๐๐ ๐๐จ๐ง๐ค ๐๐ซ ๐๐ฑ๐๐๐ฅ ๐๐จ๐๐๐ก
The IF Function is probably the most important function you can learn in Excel. So in this video, I've put together 10 examples of how to use it from easy to hard. First, we'll start with a simple IF statement with greater than as the logical test. Then, we'll learn the IFS formula. Third, we'll learn to combine formulas such as the IF AND. Fourth, we'll look at other formulas that use IF such as the SUMIFS or the COUNTIFS.
#if #excel #excelfunctions #excelformulas
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
๐ File Link:
https://docs.google.com/spreadsheets/...
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
Chapters:
0:00โ -โ intro
0:10โ -โ IF Formula single criteria
0:26โ -โ IF Formula 2 criteria
2:34โ -โ IF Formula multiple criteria
3:21โ - Nested IF simple example
4:57โ - IF AND Formulas Combination
6:20 - Nested IF and IFS
9:54 -IF + AND
12:31 - SUMIF and COUNTIF
15:04 - Outro
Join this channel to get access to perks:
ย ย ย /ย @office-monkย ย
Intro Clip / Video Credit: Vecteezy
@Vecteezy