Excel Formulas

 Hello Friends,

This is Amey Kulkarni

In this Blog I will Share Few Formulas for you. I will share the My Channel in last.

So Let's begin...

1. Sum = It usually use for aggregates vales from a selection of columns or rows from your selected range.  =SUM(number1, [number2],...) 
2. Average = It usually use for simple averages of data such as the average number of marks in Marksheet. =AVERAGE(number1, [number2],...) 
   
3. Count = It usually use for counts al cells in each range that contain only numeric values.  =COUNT(value1, [value2],...) 
   
4. CountA = It usually use for counts all cells in each range. However, it counts all cells regardless of type.  =COUNTA(value1, [value2],...) 
   
5. If = It usually use when you want to sort your data according to a given logic. =IF(logical_test,[value_if_true], [value_if_false]) 
   
6. Trim = It usually use to ensure that all empty spaces are eliminated. TRIM only operates on a single cell.  =TRIM(text) 
   
7. Max = It usually use to find a maximum number in a range of values. =MAX(number1, [number2],...) 
   
8. Min = It usually use to find a minimum number in a range of values. =MIN(number1, [number2],...) 
   
9. Today = It use to return the Current date.  =TODAY() 
   
10. Upper = It Convert text in cell to Upper case.  =UPPER(text) 
    
11. Lower = It Convert text in cell to Lower case.  =LOWER(text) 
    
12. Proper = It Convert text in cell to Proper case  =PROPER(text) 
    
13. Len = It used to calculate the value in a cell.  =LEN(text) 
    
14. Left = It use to cuts a text from left.  =LEFT(text, [num_chars]) 
    
15. Round = It use to rounds a number to nearest decimal places we define. =ROUND(number, num_digits) 
    
16. Row = It tells you the current row numbers.  =ROW([reference]) 
    
17.   Mid = It returns a specific number of characters from a text starting at the position you specify  =MID(text,start_num,num_chars) 
    
18. Concatenate = It joins several text items into one text item. =CONCATENATE(text1,text2,….) 
    
19. AND = It returns True if all of its arguments are TRUE. =AND(logical1,logical2,….) 
    
20. Product = It Multiplies it arguments. =PRODUCT(number1,number2,….) 
    
21. Hyperlink = It creates a shortcut to a file or internet address. =HYPERLINK(link_location,[friendly_name]) 
    
22. Match = It searches for a value in an array and return the relative position of that item. =MATCH(lookup_value,lookup_array,[match_type]) 
    
23. Transpose = It Converts a vertical range of cells to a horizontal range and vice versa. = TRANSPOSE(array) 
    
24. Now = Returns the current date and time formatted as a date and time. =NOW() 
    
25.  Date value = It Converts a date in the form of text to a number that represents the date in the excel date-time code. =DATEVALUE(date_text) 
    
26. Count Blank = It Counts the Blank Cells in given range. =COUNTBLANK(range) 
    
27. Product = It Multiply numbers in Row or Column. =PRODUCT(number1, Number2, ….) 
    
28. Frequency = It Calculates how often value occur within a range of values, and then returns a vertical array of numbers. =FREQUENCY(data_array,bins_array) 
    
29. CountIf = It Counts the number of cells within a range that meets the given conditions. =COUNTIF(range,criteria) 
    
30. Subtotal = It Returns a subtotal in a list or database. =SUBTOTAL(function_num,ref1,…) 
    
31. Sum Products = It Returns the sum of the multiplication of corresponding ranges or arrays. =SUMPRODUCT(array1,array2,….) 
    
32. If = It Check whether a condition is met, and returns one value if TRUE, and another value if FALSE. =IF(logical_test,[value_if_true],[value_if_false]) 
    
33. Rept = Repeats text a given number of times. =REPT(text,number_times)