Page 210 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

Logical_test is any value or expression that can be evaluated to true or Notes
alse.
Value_if_true is the value that is returned if iogical_test is true.
Value_if_false is the value: that is returned if logical_text is false.

Up to seven IF functions can be nested as value_if_true and value_if_false
arguments to construct rnore elaborate tests. The result values can display
text with an argument such as “Hello”, calculate a formula such as B12*6
or display the contents of a cell such as D35. Consider the following
formula
lF(834>5O, 834*2, “Entry tool low!”)
ln this example, the IF( )funcion prociucesthe answer 110 if B34 is 55.
lf B34 is 12, however, the celi that contains the function display the text
given below.
Entry too low!

AND The AND function joins test conditions. Returns TRUE if all its logical
arguments are TRUE; returns FALSE if one or more logical arguments is
FALSE.

Syntax: AND(logical’1, logical2...)
AND(TRUE, TRUE) returns TRUE.
AND(TRUE, FALSE) returns FALSE.
AND(2+2=4 ,2+3:5) returns TRUE.

OR Returns TRUE if any argument is TRUE.
Syntax: OR(logical1 ,logical2, ...)

Logical1 , logical2, ... are 1 to 30 conditions you want to test that can be either
TRUE or FALSE.
OR(1 +1:1, 2*2:5) returns FALSE.

lf A1:A3 contains the values TRUE, FALSE and TRUE, then
OR(A1:A3) returns TRUE.
NOT Reverses the logic of its argument.

Syntax: NOT(logical)
NOT(FALSE) returns TRUE.
NOT(1 +1=2) returns FALSE.

10.8.4 Mathematical and Trigonometric Function
Mathematical and trigonometric functions provide the foundation for the majority of
worksheet calculations. Most scientific and engineering functions are found under
mathematical functions.
ABS: The ABS function returns the absolute value of a number.
Syntax: ABS(number) Number is the real number for which you want the
absolute value.

LOVELY PROFESSIONAL UNIVERSITY 203