using the if function simple
TRANSCRIPT
Using the IF Function
The IF function can be quite useful in a spreadsheet. It is a
Logical function and can be used to choose one of two values to put into a cell.
Here are some different Conditional Operators we could use:
> More than< Less Than
>= Greater than Or Equal To<= Less than Or Equal To
<> Not Equal To
If my score is more than 80 I passed
PASS ( I passed)
FAIL (I failed)
IF(cell reference >80,”PASS”,”FAIL”
Click on me to try out the
function
If I have £1000 or more in my account
YES (I can go on holiday)
NO (I can’t)
IF(cell reference >=1000,”YES”,”NO”
If there are less than 100 in stock
RE-ORDER (i need more stock)
NO (There is enough stock left)
IF(cell reference <100,”RE-ORDER”,”NO”