Excel Formulas

  Hello Friends,

This is Amey Kulkarni from Amey Knowledge Hub.

In this Blog I will Share Few 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	PRODUCT	In This Formula It Multiply Numbers in Row or Column	=PRODUCT(number1,number2)
2	CONCATENANTE	In This Formula We Can Add All the Words In 1 Cell from Corresponding Cells	=CONCATENATE(text1,text2,text3)
3	ROW	In This Formula It Helps to Create Row Numbers	=ROW(reference)
4	COLUMN	In This Formula It Helps to Create Column Numbers	=COLUMN(reference)
5	ROUND	In This Formula It Round Off to Nearest Number	=ROUND(number,num_digits)
6	ROUND UP	In This Formula It Round Up to Nearest Number	=ROUNDUP(number,num_digits)
7	ROUND DOWN	In This Formula It Round Down to Nearest Number	=ROUNDDOWN(number,num_digits)
8	LOOKUP	In This Formula It Is Used to Find Value Against Specific Cell	=LOOKUP(lookup_value,lookup_vector,result_vector)
9	TODAY	This Formula Is Used for Current Date	=TODAY()
10	NOW	This  Formula Is Used for Current Date & Time	=Now()
11	YEAR	This Formula Is Used to Search Year from A Particular Date	=YEAR(serial_number)
12	MONTH	This Formula Is Used to Search Month from A Particular Date	=MONTH(serial_number)