Answer the following question? If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, ''pass'', ''fail'') Write an IF statement so that if the number in Cell A2 is less...

Answer the following question?

• If the cell B2 is 68, what will this IF function give you as a result?

=IF (B2>60, ''pass'', ''fail'')

• Write an IF statement so that if the number in Cell A2 is less than 100 the formula displays the text “Within budget”, otherwise the formula displays the text “Over budget”.