To do this task, write the following formula in the cell B1.=If(A1=10Ex5: The cell A1 can contain only values that start from 10 downward.
To do this task, write the following formula in the cell B1.=If(A120,'Invalid value',' ')Ex3: If values in the cell A1 is less than 20, the cell B1 displays 'Valid value' on the contrary, the cell B1 displays 'Invalid value'. Otherwise the cell B1 displays blank.To settle the example, you need to write the following formula in the cell B1.=If(A1='m','Male',')Ex2: If values in the cell A1 is greater than 20, the cell B1 displays 'Invalid value'. If you type m or M in the cell A1, the cell B1 displays 'Male'.
Comparison operatorMeaningExample= (equal sign)Equal toA1=B1 (greater than sign)Greater thanA1B1= (greater than or equal to sign)Greater than or equal toA1=B1 (not equal to sign)Not equal toA1B1The following examples demonstrate each comparison operator.Ex1. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE. Write the following formula:=4^5Alternatively, you can write the formula as below:=POWER(4,5) II.2.Comparison operatorsYou can use the following operators to compare two values. Open Microsoft Office Excel.2.Ĭlick on any cell.3. In Excel, to calculate exponentiation, you use Caret operator or POWER function.įor instance, you want to calculate 4^5. Caret (^)You use caret operator to raise a number to a power.įor example, 3^4. You can also use shortcut key to display the value as percentage by pressing ctrl+ shift+%. If you type 0.3 in the cell, when you click percent sign in the Number group, Excel displays the value as 30%. Percent sign (%)You use percent sign to display the value of the cell as percentage. For example, divide value1 by value2 and then multiply value3 to the result.II.1.5. Forward slash(/)You use forward slash to divide numeric values.
M s excel 2007 tutorial pdf#
Ms Excel Formulas Tutorial 2007 Pdf Ms Excel 2007 Formula Tutorial Pdf Downloadįor example, multiply value1 by value2 and then subtract value3 to the result.II.1.4. Asterisk (.)Asterisk is used to multiply numeric values. Minus sign (-)Minus sign (-) is used to subtract two or more numeric values or represent negative values.įor instance, subtract value1 by value2.II.1.3. For example, add value1 and value2.II.1.2.
M s excel 2007 tutorial plus#
Plus sign (+)Plus sign (+) is used to add two or more numeric values. (asterisk)Multiplication5.5/ (Forward slash)Division5/2% (percent sign)Percent30%^ (caret)Exponentiation5^2II.1.1. Arithmetic operatorMeaningExample+ (plus sign)Addition5+5- (minus sign)SubtractionNegation5-3-2. Arithmetic operatorsThe following arithmetic operators use to perform basic mathematic operation such as addition, subtraction, multiplication, or division combine number and produce numeric result. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. Using calculation operators in formulaYou use operators to perform calculation on the elements of a formula.
M s excel 2007 tutorial pdf download#
0 kommentar(er)
