How to Create a Conditional Formula in Excel 2007

How to Create a Conditional Formula in Excel 2007. When a user first experiments with the conditional formulas in Excel 2007, it can seem foreign. What does true and false have to do with a spreadsheet where number reign supreme? However, conditional formulas are actually quite simple once a person uses then a few times.

Step

Open an existing or new Microsoft Excel 2007 document. Click "Start" from the main operating system menu. Then choose "Programs" from the start menu. Select "Microsoft Office" from the programs menu. Next, choose "Microsoft Excel" from the Microsoft Office menu. Now either choose "New" from the main menu or locate the existing Excel document to use for a conditional formula.

Step

Establish the parameters for the conditional formula. For example maybe a person can create a conditional formula for an invoice discount. That way if the invoice is paid in under a certain number of days then a client would receive a percentage discount.

Step

Structure the conditional formula. In this example say that if the invoice is paid in less than thirty days, the customer receives a five percent discount. The conditional formula would look like this: IF((C5-B5)

Step

Type the conditional formula in the spreadsheet. A person can either type the formula in or use the conditional function. To use the conditional function click on the "Formulas" tab and choose the "Logical" option from the format library.

Step

Enter the conditional formula in the "If" formula function dialogue box. Once the "If" function dialogue box appears enter the previous formula parameter in the provided input boxes. In the "Logical_test" box enter "C5-B5

Step

Test and save the Microsoft Excel 2007 spreadsheet. Be sure that the conditional formula is working correctly by observing the results and check them against the known data. When the formula is satisfactory, save and close the spreadsheet.