• Share

Discuss in my forum

# Data for the Excel IF Function Format Tutorial

## How to Copy the Tutorial Data into an Excel Worksheet

IF Function Formatting Tutorial

Note: This article gives instructions for copying the sample data shown below into an Excel worksheet.

The data accompanies the Excel IF Function Format Tutorial Part 1.

### Use Copy and Paste Special to Transfer Tutorial Data

1. Drag select the data in the table below to highlight all of it. Be sure to select the entire table.

3. Open Excel 2007.

4. Click on cell D1 in the worksheet to make it the active cell.

5. Click on the Home tab.

6. Click on the down arrow below the Paste button on the ribbon to open the drop down menu.

7. Choose Paste Special from the menu to open the Paste Special dialog box.

8. Choose Paste as Text from the options in the dialog box.

Each piece of data should be pasted into a separate cell in the worksheet. The data should fill the range D1 to G8.

If your data does not end up in cells D1 to G8 it probably means you didn't use Paste Special correctly. Use Excel's Undo feature to remove the data and then try steps 4 to 8 above again.

Note: The dollar signs ( \$ ) located inside the IF functions in the table below are used to indicate absolute cell references rather than currency formatting.

## Tutorial Data for the Excel 2007 IF Function Step by Step Tutorial

 Deduction Calculations For Employees Deduction Rate <30000: 0.06 >=30000: 0.08 Name Salary Deduction Smith B. 45987 =IF(E7<30000,\$E\$3*E6,\$E\$4*E6) Wilson C. 23412 =IF(E8<30000,\$E\$3*E7,\$E\$4*E7) Thompson J. 67265 =IF(E9<30000,\$E\$3*E8,\$E\$4*E8) James R. 27354 =IF(E10<30000,\$E\$3*E9,\$E\$4*E9) Ramirez A. 34678 =IF(E11<30000,\$E\$3*E10,\$E\$4*E10)

Ted French