Basic IF Statement - OWLL - Massey University
Information Commons - IT Help Sheet
IF statement
You need to think logically when you do an IF statement. Working on paper and pencil may help you to perform an IF statement before you directly type your statement into the cell. An IF statement is a conditional test on values and formulas that returns one value if a condition you specify is TRUE and another value if it is FALSE.
IF(logical_test,value_if_true,value_if_false)
Basic IF Statement
For example, if the following sales people sold more than 45 items, in the assessment cell it should say "PASS", otherwise, "FAILED".
IF the sales > 45 say "PASS"
ELSE "FAILED"
1. Select the cell where your result should go to, e.g. C2
Formulas tab > Formula Library Group > Logical drop list > Choose IF
Page 1 of 5
Information Commons - IT Help Sheet
2. Type logical test and the value for true and false > Click OK
(1)
(2)
(3)
Tip: If the value is text such as PASS and FAILED, put speech marks around a word so Excel can recognise that it's text.
(in the assessment cell) IF Sales item is more than 45 PASS If it's not, FAILED (display this!)
C2 Use IF statement (1) C2 >=45 (2) "PASS" (3) "FAILED"
If C2 is greater than 45 If C2 is greater than or equal to 45 If C2 is less than 45 If C2 is less than or equal to 45 If C2 is equal to 45
C2>45 C2>=45 C2 ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- microsoft excel 2013 basic customguide
- excel formulas university of detroit mercy
- conditional formatting
- advanced excel formulas functions
- excel formatting best practices in financial models important
- formatting spreadsheets in microsoft excel
- microsoft excel tutorial
- basic if statement owll massey university
- microsoft excel manual
Related searches
- if statement based on cell color
- conditional formatting if statement color
- if statement to change cell color
- excel if statement based on color
- excel if statement to change cell color
- conditional if statement excel
- if statement with multiple criteria
- count if statement in tableau
- tableau if statement multiple values
- nested if statement in tableau
- if statement in tableau calculated field
- tableau if statement with dates