Excel Formulas - Part 2

  Hello Friends,

This is Amey Kulkarni from Amey Knowledge Hub.

In this Blog I will Share Few Keyboard Formulas for you,  I have also made a video on the same. I will share the Link of the video and My Channel in last.

So Let's begin...

Sr No	Formula Name	Description of Formula	Formula Syntax
1	COUNTIF	In This Formula It Counts the Specific Data in Given Range	=COUNTIF(RANGE,CRITERIA)
2	COUNTBLANK	In This Formula It Counts the Blank Cells in Given Range	=COUNTBLANK(range)
3	COUNTA	In This Formula It Counts the Total No of Cell in Given Range	=COUNTA(value1,value2)
4	COMPOSE TEXT WITH &	To Add Multiple Text Using & Sign	=text1 & text2 & text3
5	UPPER CASE	To Convert Text into Upper Case	=upper(text)
6	LOWER CASE	To Convert Text into Lower Case	=lower(text)
7	PROPER CASE	To Convert Text into Proper Case	=Proper(text)
8	SORT LEFT TO RIGHT	To Sort Values from Left to Right	Data - Sort - Option - Left to Right - select Row
9	SELECT BLANK CELL	To Select Blank Cell in The Range Given	Select Data - F5 (to open Go to Window) - Special - Blank - Then Enter data in any cell and hold Ctrl then press Enter