Formulas in Microsoft® Office Excel 2010

Microsoft Office Excel 2010 is the latest version released by Microsoft. It comprises of many features that increases both user and system performance. Formulas are the special feature of Microsoft Office Excel 2010. It contains many functions like Date Function, Math Function, Count Function, etc. All these function will help you do many tasks easily and quickly. You can easily access the formulas in Microsoft Office Excel. In the toolbar, you have an option of Formulas. As you click on this tab, you get all predefined formulas of Microsoft Office Excel 2010. By using these formulas you can also save complex calculation time. It also provides the tips to use each formula. You need to input values in cells and then collect the output from desired cell.

• Date Function
• Math Function
• Count Function

Date Function

Date Function contains many formulas to calculate date. NETWORKDAYS is used to count the number of working days between two dates. DATEDIF is used to count the number of days between dates. DAYS360 Function is used in accounting systems for calculating the number of days between two dates based on a 360-day year. EDATE function is for calculating a due date of a project or investment which falls on the same day of the month as on the date it was issued.

Math Function

SUM function is used to quickly add up the values in a range of cells. SUMIF function is used to determine if a specified condition is true or false. PRODUCT function is used to determine the product of two numbers. QUOTIENT is used to divide numbers in Microsoft Office Excel.

Count function is used to count the number of cells containing numbers in a selected range. COUNTIF function is to count the number of cells in a selected range that meet specified criteria. COUNTA function allows you to count the number of cells containing numbers, dates, formulas or text labels in a selected range. COUNTBLANK function helps you to count the number of cells in a selected range that meet certain criteria.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 can provide the best issue resolution and customer satisfaction.

• Comprehensive support for different formulas used in Microsoft Office Excel 2010
• Diagnostic & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices, and peripherals
• Optimize your computer’s speed and performance.