Manual

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