Basic IF Statement - 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
- excel if the university of memphis
- sugi 28 generating custom excel spreadsheets using ods
- basic if statement massey university
- how to apply conditional formatting to a cell
- conditional formatting in microsoft excel
- excel formatting best practices in financial models important
- 224 2008 proc report in color what s your style
- how to color your report lex jansen
- the report procedure and ods destination for microsoft
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