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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- spreadsheet for password and username
- dividend reinvestment spreadsheet template
- basic excel spreadsheet instructions pdf
- spreadsheet to track loan payments
- student loan repayment spreadsheet tem
- excel spreadsheet templates small business
- roi for equipment spreadsheet template
- excel spreadsheet student loan repayment
- start up costs spreadsheet template
- startup business spreadsheet templates
- student loan repayment spreadsheet temp
- real estate investment spreadsheet template