Spreadsheet



Excel Spreadsheet -Spreadsheet Functions 1

Constants

TRUE

---A logical constant returned when the condition is satisfied.

Example

6 > 2 returns TRUE

FALSE

---A logical constant returned when the condition is not satisfied.

Example

-5 < -3 returns FALSE

Operators

+, -, *, /

---Arithmetic operations

Example

2*3/6+2 returns 3

, =, , =

--- Returns a logical constant after comparison. String comparisons are based on the ASCII code table.

Examples

1. 38) equals TRUE

4. If A1:A3 contains the values FALSE, FALSE, and TRUE, then: AND(A1:A3) equals FALSE

5. If C4 contains a number between 50 and 200, then: AND(40 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download