Wednesday, November 14, 2007

How to use formulas in Microsoft Excel

This blog will enable viewers to learn much about the various formulas on the insert,functions (fx) menu of microsoft excel.People are paying more to learn less in my community.I want to use this medium to allow viewers to understand that excel as to do with practice as practice makes one perfect. Examples are shown below:
DAYS360:Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
Syntax
DAYS360(start_date,end_date,method)
Start_date, end_date are the two dates between which you want to know the number of days. If start_date occurs after end_date, DAYS360 returns a negative number. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
CONCATENATE
Joins several text strings into one text string.
Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Note:You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).

0 comments: