IF Statements

We want to check if A4 is less than or equal to 650. If true, we want to return "Within budget". If false, we want to return "Over budget".

What is the missing symbol from this statement?

=IF(A4 [fill in blank] 650, , "Within budget", "Over budget")

(a)  

We want to check if A6 is equal to 70. If true, we want to return "Within budget". If false, we want to return "Over budget".

What is the missing symbol from this statement?

=IF(A4 [fill in blank] 70, , "Within budget", "Over budget"

(a)  

What does the < symbol mean?

• Equal to

• Greater than

• Less than

• Greater than or equal to

What does the symbol > mean?

• Greater than

• Equal to

• Less than

• Less than or equal to

What does the symbol = mean?

• Greater than

• Equal to

• Less than

• Greater than or equal to

What does this symbol >= mean?

• Greater than

• Greater than or equal to

• Less than or equal to

• Equals to

What does the <= symbol mean?

• Greater than

• Less than

• Less than or equal to

• Equal to

In cell A2 - we want to check if the budget is greater than 400. If true we want to return "Over budget". If false, we want to return "Under budget".

How would we write this IF statement?

• =IF(A2>400, "Over Budget", "Under budget")

• =IF(A2<=400, "Over Budget", "Under budget")