Logical Functions
1
Logical Functions Function Description AND Returns TRUE if all of its arguments are TRUE FALSE Returns the logical value FALSE IF Specifies a logical test to perform IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula NOT Reverses the logic of its argument OR Returns TRUE if any argument is TRUE TRUE Returns the logical value TRUE
-
Upload
tipu-sultan -
Category
Documents
-
view
212 -
download
0
description
MS LOGICAL FUNCTIONS
Transcript of Logical Functions
-
LogicalFunctions
Function Description
AND ReturnsTRUEifallofitsargumentsareTRUE
FALSE ReturnsthelogicalvalueFALSE
IF Specifiesalogicaltesttoperform
IFERROR Returnsavalueyouspecifyifaformulaevaluatestoanerror;otherwise,
returnstheresultoftheformula
NOT Reversesthelogicofitsargument
OR ReturnsTRUEifanyargumentisTRUE
TRUE ReturnsthelogicalvalueTRUE
http://www.investintech.com/prod_downloadsa2e.htm