IF FUCTIONS The If function allows the Spreadsheet to make decisions, based on conditions.
The If function has the following format: =IF(<Condition> , <True value> , <False value>)
The Condition is the problem to be evaluated. eg. Amount of wages someone earned to determine their tax bracket.
The True value is the action to be taken if the given condition is fulfilled. This may be to add a value to something or multiply a value by something etc.
The False value is the action to be taken if the condition is not fulfilled.
In any given case, either the False or True actions can be done, as a condition is either True or False, but never both.
In Excel, a cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and rownumber that intersect at the cell's location. Note that when listing a cell reference, the column letter is always listed first.
SPREADSHEET FUNCTIONS The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of a cell.
Microsoft Word is a word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenixsystems.[1][2][3] Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIX, OS/2, and Microsoft Windows (1989). It is a component of theMicrosoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Office Word 2010 for Windows and Microsoft Office Word 2011 for Mac.