Table of Contents
Advertisement
I BONUS = .04*SALES
BONUS= Sr_0.00
t
I BONUS: .02*SALES
BONUS= $150.00
BONUS= IF(SALES<IOOOO,.O2*SALES,.O4*SALES)
I
For sales over $10,000, the bonus is 4%. The formula for such an IF statement
shown in the box above is =IF(C4<10,000, 0.2 * C4, .04"C4) where the sales
figure is located in cell C4.
In this example, SALES<10000 is the condition
you want to test, .0Z*SALF_ is
the result you want ff the condition
is true, and .04*SALESis the result you
want if the condition is false. Therefore,
if the SALES figure is $15,000 then
the IF statement
returns false, and Spreadsheet
computes
the formula as in
the box at the left.
If, on the other hand, the SALES figure is $7,500, then the IF statement
returns
true, and Spreadsheet
computes
the formula as in the box at the left.
Logical Function
example:
combining
functions
By combining
IF with the AND and OR functions,
you can create
even
more
complex
conditional
statements.
Consider
the following
examples:
=IF(AND(AI>100,BI>100,Cl>IOO),5,0)
The
result of this formula
is 5 only if the values in A1, B1, and C1 are all
greater
than 100. Otherwise
the result
is 0. You can apply
the same
principle
using
the OR function,:_
shown
in the following
example:
:!IF-(OR(A1> 100,B1> 100),50,O)
The result
of this formula
is 50 if either
A1 or B1 is greater
than 100;
otherwise,
the result is 0.
Using Logical operators
in Logical Functions
You can also use conditional
operators
that result in a value
of 0 if false or 1
if true.
These
operators
are used
with IF functions.
SYMBOL
>
<
(CTRL+
MENU
+ >)
(CTRL
+ MENU + <)
(CTRL
+ MENU + =)
OPERATION
iGreater
than
Less than
Greater
than or equal to
Less than or equal
to
Not equal
EXAMPLE
A14>B12
A14<B12
A14_.B12
A14_B12
A14#B12
Appendix 221
Advertisement
Table of Contents
