ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What are some formulas of MS Excel?

user-image
تم إضافة السؤال من قبل muddasar khan , Police Deparment , Khyber Pakhtunkhwa Police Department
تاريخ النشر: 2015/12/23
Murali Krishnan A Athiyarath House
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Muhammed Musthafa PH , Chief Accountant , Line Investments& Property LLC

Answer is ALT key and equal key

Manzoor Mukthesar
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Marian Sychelle Fajardo , Head – , ANGELINE CUA

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

المزيد من الأسئلة المماثلة