Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are some formulas of MS Excel?

MS Query Microsoft Excel Computer Skills MS Office tools
user-image
Question added by muddasar khan , Police Deparment , Khyber Pakhtunkhwa Police Department
Date Posted: 2015/12/23
Upvote (1) Views (22) Followers (17) Answers (16) Report Question
Write an Answer
Register now or log in to answer.
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.

Md. Ashraful Alam

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

R SAI KRISHNA

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 , Head – , ANGELINE CUA

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

See More Answers
Write Your Answer
More Questions Like This