EXCEL FORMULAS :-

EXCEL SOME EXAMPLE FORMULAS
Ctrl + ; Date
Ctrl + Shift ; Time

Cases Formula 

UPPER   CASE      :-  =UPPER(A2)           SKYKISH

LOWER CASE      :-  =LOWER(A2)          skykish

UPPER CASE        :-  =PROPER(A2)         Skykish

Combine first and last names 
A                    B
First Name    Last Name
Nancy           Davolio
Andrew         Fuller
Formula Description (Result)
=A2&" "&B2 Combines the names above, separated by a space (Nancy Davolio)
=B3&", "&A3 Combines the names above, separated by a comma (Fuller, Andrew)
=CONCATENATE(A2," ",B2) Combines the names above, separated by a space (Nancy Davolio) 

Compare one cell to another cell
Data
BD122
BD123
BD123
Formula Description (Result)
=EXACT(A2,A3) Compare contents of A2 and A3 (FALSE)
=EXACT(A3,A4) Compare contents of A3 and A4 (TRUE) 

Check if a cell has any text in it
Data
Davolio
123
Formula Description
=ISTEXT(A2) Checks to see if cell A2 has text (TRUE)
=ISTEXT(A3) Checks to see if cell A3 has text (FALSE)

Convert measurements 
A)  Data
6
Formula Description (Result)
=CONVERT(A2,"C","F") Convert 6 degrees Celsius to Fahrenheit (42.8)
=CONVERT(A2,"tsp","tbs") Convert 6 teaspoons to tablespoons (2)
=CONVERT(A2,"gal","l") Convert 6 gallons to liters (22.71741274)
=CONVERT(A2,"mi","km") Convert 6 miles to kilometers (9.656064)
=CONVERT(A2,"km","mi") Convert 6 kilometers to miles (3.728227153)
=CONVERT(A2,"in","ft") Convert 6 inches to feet (0.5)
=CONVERT(A2,"cm","in") Convert 6 centimeters to inches (2.362204724)

B)  Data
Formula Description (Result)
=CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms (0.453592)
=CONVERT(68, "F", "C") Converts 68 degrees Fahrenheit to Celsius (20)
=CONVERT(2.5, "ft", "sec") Data types are not the same so an error is returned (#N/A)
=CONVERT(CONVERT(100,"ft","m"),"ft","m") Converts 100 square feet into square meters (9.290304).

Convert between time units
Data
6
Formula Description (Result)
=CONVERT(A2,"day","hr") Convert 6 days to hours (144)
=CONVERT(A2,"hr","mn") Convert 6 hours to minutes (360)
=CONVERT(A2,"yr", "day") Convert 6 years to days (2191.5)

Count all of the cells in a range
Data Data Data Data
15,000 28,500    55,000 87,000
9,000 13.700  63,800 23,000
8,000 1000 19,000 99,900
Formula Description (Result)
=ROWS(A1:D4) * COLUMNS(A1:D4) The total number of cells in the range (16)

Count numbers greater than or less than a number
Salesperson      Invoice
Buchanan      15,000
Buchanan        9,000
Suyama                8,000
Suyama              20,000
Buchanan        5,000
Dodsworth      22,500
Formula Description (Result)
=COUNTIF(B2:B7,">9000") Numbers above 9000 (3)
=COUNTIF(B2:B7,"<=9000") Numbers less than or equal to 9000 (3)
=SUMPRODUCT((B2:B7>=9000)*(B2:B7<=22500)) The SUMPRODUCT function counts the number of cells in the range B2:B7 that contain numbers    greater than or equal to 9000 and less than or equal to 22500 (4).

Calculate the factorial of a number
Data
6
Formula Description (Result)
=FACT(A2) Factorial of 6, or 6*5*4*3*2*1 (720)
=FACT(3) Factorial of 3, or 3*2*1 (6)
=FACT(A2+4)  Factorial of 10 (3628800)

Raise a number to a power
A B
Formula Description (Result)
=POWER(5,2)  Calculates five squared (25)
=5^3  Calculates five cubed (125)