Brother International PDP350CJ Owner's Manual - English - Page 190

Spreadsheet

176

IF statements

consist of the following three components:

S

The condition you want to test

S

The result you want if the condition is true

S

The result you want if the condition is false

For example, you might want to calculate escalating bonuses for a sales

team based on a percentage of the sales, located in cell C4. For sales

under $10,000, the bonus is 2%. For sales over $10,000, the bonus is 4%.

The formula for such an IF statement shown in the box at the left 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; .02*SALES

is the result you want if the condition is true, and .04*SALES is 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.

Using Logical Operators

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

OPERATION

EXAMPLE

>

Greater than

A14>B12

<

Less than

A14<B12

(

CODE

+

MENU

+

>

)

Greater than or equal to

A14

≥

B12

(

CODE

+

MENU

+

<

)

Less than or equal to

A14

≤

B12

(

CODE

+

MENU

+

=

)

Not equal

A14

≠

B12

Using

the AND and OR Functions

By combining IF with the AND and OR functions, you can create even

more complex conditional statements. Consider the following examples:

=IF(AND(A1>100,B1>100,C1>100),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, as shown in the following example:

=IF(OR(A1>100,B1>100),50,0)

The result of this formula is 50 if either A1 or B1 is greater than 100;

otherwise, the result is 0.

BONUS =

IF(SALES<10000,.02*SALES,.04*SALES)

BONUS =

.04*SALES

BONUS = $600.00

BONUS =

.02*SALES

BONUS = $150.00

See Appendix for list of AND and

OR functions.

Section	Page
Contents	1
Getting Started	12
File Manager	73
Word Processing	84
Spreadsheet	153
Drawing	220
Scrapbook	263
Addressbook	270
Planner	285
Calculator	302
Typewriter	313
Book Reader	326
Desktop Reference	331
Text File Editor	334
Games	339
Scanner	346
Modem	351
Appendix	380
Glossary	415

Brother International PDP350CJ Owner's Manual - English - Page 190

Using Logical Operators, the AND and OR Functions, BONUS, BONUS = $600.00

Page 190 highlights