Learning Computer Skill Blog

                       PART -2               👉 LOGICAL FUNCTION 1. IF FUNCTION Summary  The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR. Purpose  Test for a specific condition Return value  The values you supply for TRUE or FALSE Syntax     =IF (logical_test, [value_if_true], [value_if_false]) Arguments  logical_test  - A value or logical expression that can be evaluated as TRUE or FALSE. value_if_true  - [optional] The value to return when logical_test evaluates to TRUE. value_if_false ...

EBEES INFOTRAIN CONSULTANCY SERVICES PVT. LTD. 1. SUM :  Summary  The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...) Examples In the example shown, the formula in D12 is: = SUM ( D6:D10 ) // returns 9.05 2.Round() :  Summary  The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point. Purpose  Round a number to a given number of digits Return value  A rounded number. Syntax  =ROUND (number, num_digits) Arguments  number  - The number to round. num_digits  ...