Wednesday, January 11, 2012

How to Use Less Than or Equal to Function in Excel


1. Select the cell to display the calculated result and insert the function for the comparative formula (by selecting 'Function' under 'Insert' in the top menu bar). Make sure to review the format of the formula in the dialog box to identify the information to be entered. For example, the formula format for IF is '=if(logical_test, value_if_TRUE, value_if_FALSE)' where the logical test is the comparative rule or conditional criterion, value-if-TRUE generates a response when both conditions match and value-if-FALSE generates a different response if both conditions do not match.
2. Type '(' and then select the cell containing the value for the criterion or type the desired value. For example, after the function '=if' is generated, type '(' and then select the A3 cell to display '=if(A3' in the formula bar.
3. Type '
4. Type ')', other information as specified by the formula format (in Step 1) and then press the 'Enter' key to complete the function. For example, the desired calculation will generate a display of 4 if the value in A3 is less than or equal to 100 or 500 if the value in A3 is greater than 100. The complete formula would read '=if(A3
5. Explore other functions to create comparative formulas such as COUNTIF and SUMIF where '

Blogger news