Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are some formulas of MS Excel?

user-image
Question added by muddasar khan , Police Deparment , Khyber Pakhtunkhwa Police Department
Date Posted: 2015/12/23
Murali Krishnan A Athiyarath House
by Murali Krishnan A Athiyarath House , Manager Analyst , ZAFCO FZCO

If your using sum formula in excel you can press short cut key Alt+=

Marwan Itani
by Marwan Itani , Senior System Engineer , iTel International

You should be more specific. You can either go to "formulas" tab then select insert formula, or you can click on the function button that is above the column letters.

Anbu Steffnov
by Anbu Steffnov , Human Resource Sepcialist , Enhance Group,Oman

click on the cell the formula to be implemented. Start with "=" and enter the formula required.

For example "=Sum(A1:A)" and press enter 

Manik Hussain
by Manik Hussain , English Teacher(grammar and speaking) , Aptech Education

SUM Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

Count Formula: =COUNT(A1:A10)

Muhammed Musthafa PH
by Muhammed Musthafa PH , Chief Accountant , Line Investments& Property LLC

Answer is ALT key and equal key

Manzoor Mukthesar
by Manzoor Mukthesar , Warehouse Supervisor , HOSHANCO HOLDING

In Excel 2010, there are many templates that can save you a lot of time. A template is a predesigned spreadsheet you can use to create new spreadsheets with the same formatting and predefined formulas.

To SUM, Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

Rahmat Ullah Khan
by Rahmat Ullah Khan , Administrative Asst , Trojan Holding

If you want addition =sum (A1,B1) Where symbol = is use for formula SUM for function () for cells or range. Simply =A1+B1 means add A1 and B1 same like this =A1*B1 means multiplication =A1/B1 mean dividing. There are many different types of formulas used as per their requirements. Vlook up Hook up Countif Sum Average etc etc

lick on the cell the formula to be implemented. Start with "=" and enter the formula required. For example "=Sum(A1:A)" and press enter.

If your using sum formula in excel you can press short cut key Alt+=

Kaleem Abbas Abbas
by Kaleem Abbas Abbas , Senior Accountant , Business Professionals Education Centre

You should be more specific. You can either go to "formulas" tab then select insert formula, or you can click on the function button that is above the column letters.The SUM formula allows you to add 2 or more numbers together.

Formula: =SUM(A1, B1) or =SUM(A1:B5)

Marian Sychelle Fajardo
by Marian Sychelle Fajardo , Assistant , SHUTTLE MARINE CO. LLC

it depends on what you are computing; see example below: =SUM(A1:A50) =A1*C1

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.