Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are some formulas of MS Excel?

user-image
Question ajoutée par muddasar khan , Police Deparment , Khyber Pakhtunkhwa Police Department
Date de publication: 2015/12/23
Murali Krishnan A Athiyarath House
par 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
par 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
par 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
par 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
par Muhammed Musthafa PH , Chief Accountant , Line Investments& Property LLC

Answer is ALT key and equal key

Manzoor Mukthesar
par 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
par 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
par 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
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?