When to use Excel's =IF() Function
Loading...
Loading...
7,344
Loading...
Uploader Comments (DannyRocksExcels)
see all
All Comments (4)
-
is it possible to have the answers have different font/cell fill colours ? for example
true = "yes" -would be green
False= "no"-would be red
Loading...
4:07
SUMIF and COUNTIF functions in Excelby AuditExcel31,056 views- 7:32
If( ) function in Excelby eLearningCentralia10,268 views
- 3:58
Nesting IF and AND functions in Excel 2007by sharonlibrarian14,519 views
- 7:34
Using AND, OR, IF Funtions in Excelby excelteacher20,465 views
- 11:17
Excel - If Functionby PCTeachME9,997 views
- 4:21
AND & OR functionby AuditExcel1,408 views
- 7:11
Excel 2007 Course: IF Function (Expert Lesson 3-5: Use the IF logic function)by TheSmartMethod10,089 views
- 4:19
Microsoft Excel #04: Excel as a Databaseby freetutorials450,335 views
- 3:17
Excel Conditional Formattingby claytonLock44,640 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun317,024 views
- 7:25
Excel Tutorial, Pivot Tables (3 of 3)by FinneyLearning86,638 views
- 5:25
See all Formulas in Excelby QueonDemand1,437 views
- 2:48
Excel If Statementsby alanbweaver1,779 views
- 33:46
excel practice testby joshwaxman263,416 views
- 2:18
The IF Function V2by AuditExcel452 views
- 6:06
Excel Tutorial, Pivot Tables (2 of 3)by FinneyLearning147,472 views
- 4:58
Excel 2003 Use conditional formattingby keystonelearningcom8,366 views
- 8:55
Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functionsby ExcelIsFun11,036 views
- 10:34
Excel Magic Trick 167p2 IF function formula: 12 Examples!by ExcelIsFun29,229 views
- 9:36
Microsoft Excel Tutorial - Complex IF Function Exampleby 599CD6,393 views
To have the font colors / cell fills chenge when the answer is TRUE, use Conditional Formatting. You can set multiple "Rules" for Conditional Formatting using formulas such as IF(). However, the color, fill, etc. for the Formatting will only change when the answer to the Comdition (If Function, etc.) is TRUE.
So, simply adjust the IF Condition to get different colors or other formatting results.
Danny Rocks
The Company Rocks
DannyRocksExcels 5 months ago
Thanks dear, its really helpful.
Nasargul 6 months ago
@Nasargul
My pleasure. Thanks for writing to tell me.
Danny Rocks
The Company Rocks
DannyRocksExcels 6 months ago