Excel Basics #22: IF function formula made easy!

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#22 Video topics:
1)Formula for bonus
2)TRUE FALSE formula
3)IF function formula for bonus
4)Put one of two numbers in a cell
5)Formula to check whether two columns are equal
6)IF function formula to check if two columns are in balance
7)Put one of two words (Test Strings) in a cell

Also see these videos:
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick 167p2 IF function formula: 12 Examples!

Category:

Science & Technology

Tags:

• Excel
• IF
• function
• formula
• for
• bonus
• or
• text
• string
• TRUE
• FALSE
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[kjhmario]

Great video! helped me a lot! :)

[ExcelIsFun]

@kjhmario , I am glad that it helped!

[AmazingEvents1]

Great videos

[ExcelIsFun]

@AmazingEvents1 , Glad you like it!

[fabiola1ist]

this is a great video. I would like to know how I can reach all your videos through you tube, there are other facilitators but you are awesome.

Fabiola

[ExcelIsFun]

Watch this video:

youtube[dot]com/excelisfun

It shows how to find all 1500 Excel videos that i have created and it shows how to find the playlists of videos for certain topics.

[dukk77777]

How can we make if fuction , to a discount... I mean the discount only applied to orders with quantity 2 or more?

[Kazshmir]

FORMULA!

[SalehMagrabi]

@ExcelIsFun I am sorry you are right, but you should use Semicolon ( ; ) instead of Comma ( , )

anyway thanks for help :)

[ExcelIsFun]

I do not know how to do it then. Sorry.