Formulas with Explain -Easy Excel

 Formulas with Explain

1.     Sum = this function calculate the sum of the selected cells.

2.    Average = it is used to calculate the average of selected                            
                        cells.

3.     Maximum = to find out the maximum value from the                                                                 selected cells.

4.     Minimum = to calculate the minimum value from the selection.

5.     Count = to count the total number of numeric cells from the selection.

6.     Abs = absolute the true +ve value.

7.     Ceiling = return value away from zero

8.     Floor = back toward zero

9.      SQRT = square root of the number.

10.   Power = to calculate the value raised to the power of specify number.

11.    Mod = return reminder after dividing number by divisor.

12.   Round = particular decimal place.

13.     Pi() = to calculate the accurate value of the pi.

14.      Date = return date format set in the setting.

15.      now = return system date and time.

16.        time = return specify time.

17.        Today = return system date.

18.        Concatenate (text, text1) = joints text to one cell.

19.         lower = change text to lower case.

20.         proper =  convert text to proper case.

21.         product = multiply the numbers.

22.         discount = to calculate the specify discount on the               amount.

23.          if condition

24.           % ( percentage)

25.          v lookup

26.     LEFT(TEXT,3) = To show the specify character of text             from left.

27.     right(text,2) = to return the specify character of text from the right.

28.     Len (text) = to return the total number of character of text.