Microsoft® Excel® 2003 Formulas
Microsoft® Excel® 2003 is an advanced application which is used for calculation, data analysis, report generation, graphical report charts etc. Microsoft Excel 2003 is a simple and interesting application which can be learned easily and it can simplify your work. This article deals with the various Microsoft® Excel® 2003 functions and formulas which might help you become skilled at Microsoft® Excel® 2003 and its formulas and you can use Microsoft® Excel® 2003 better and efficiently. The functions in Microsoft® Excel® 2003 are actually pre-written formulas. You can use these functions along with your own formulas according to the requirement. The commonly used functions are AVERAGE, SUM, MAX, MIN etc. Along with the functions and formulas, you can use mathematical operators and reference operators for calculations.
- Date and Time
The conditional formulas, as the name suggests, are used to check particular conditions such as logical comparisons and true or false conditions. The functions used to create conditional formulas are AND, NOT, OR and IF functions. For example, the column A has three rows containing values, 11, 7, 8 respectively. You need to check whether the value in A1 is greater than that in A2 and also less than that in A3. In order to check that you can give the formula ‘= AND (A1>A2, A1
Date and Time
The Date and Time formula can be used to add number of days to date or add times, calculate the difference between two times or two dates, insert the current date and time. For example, suppose you need to calculate the number of days between two particular dates, 11-02-2010 and 17-03-2010. You can either use the subtraction operator or the function NETWORKDAYS (column1, column 2).
The mathematical formulas can be used to add, subtract, multiply and divide the numbers and also to find percentage, round up a number. You could also use conditions along with the operators if needed. For example, if you want calculate the difference between two numbers 1111 and 1555 and require the result in percentage, you need to type the formula ‘= (column1-column2) %’. The ABS function could be used to get the absolute value of a number such as ‘=ABS (-2)’ returns the value 2.
The counting formula can be used to count cells that hold numbers, number of times a value occurs, cells in a series, nonblank cells etc. For example if you want count the number of nonblank cells in column A from A1 to A5, type the formula ‘=COUNTA (A1:A5)’. This would give answer – ‘5’, if no cell in the given range is left blank.
The conversion formula is used to convert values from one format to another such as text format to date format or number format etc. Text values are left aligned and numbers are right aligned. You could use the DATEVALUE function to convert text to date format and Convert function to convert a two digit number to four digits. To convert the value in cell having text format to date format, type the formula, ‘=DATEVALUE' (select the corresponding cell, type) and then press ENTER.