I am new at Excel and am trying to do this assignment but can not figure
what is meant by the value? Do you think I am suppose to make up some
amount?
Thanks
Felling dumb and dumber
The If Statement
Spreadsheets can perform logical operations by using the =IF function. The
logic is based on the premise that if something is not true than it must be
false. The following are the methods of comparison.
< is less than
> is greater than
= is equal to
<= is less than or equal to
>= is greater than or equal to
<>does not equal
The formula must start with an =IF. The format for this formula is:
=IF(Condition, argument if true, argument if false)
The condition is separated from the true argument by a comma, and then the
false argument is separated by another comma. It must always follow the
same sequence. Lets look at an example that causes us to cringe every year,
income tax:
We shall look at the last part of our income tax forms. In a new
spreadsheet please enter the following in cells A1 to A4:
A1 – Income Tax paid
A2 – Income Tax owed
A3 – Refund
A4 – Balance Due
We will enter the values and formulas in column B.
In B3 we have to enter a formula that will ask if B1 is greater than B2.
If it is, we will want to print the difference, if not we will want to print
nothing (leave the cell blank). The formula will look like the following
=IF(B1>B2,B1-B2,””)
In this formula the condition is if B1 is greater than B2, if it is than the
true answer is B1-B2, if it is not true than print nothing by typing two
quotation marks.
I would like you to put in the appropriate formula in B4.