*Articles/Excel101*

Excel training

First written: Feb-2024

last changed Mar-2024

last changed Mar-2024

## Adding an IF formula

Here we are going to add a formula to set a column to 0 or 1 depending on if the values in column `A`

are less than 10

- Click on cell
`E2`

, then in the Formula Bar field (at the top of the worksheet), enter in the following text`=IF(A2<10, 0, 1)`

- Then [while your cursor is still in Formula Bar field], left mouse-click on the bold green corner on the bottom-right of the green
`E2`

cell selection box, and drag this down to the bottom of the table (to the last data row excluding the total row). - Add a column heading reading "Ind" on
`E1`

and format that cell to be the same as the other heading cells using the Format Painter

*square*

*chevron_left*Step-8-add-a-Salary-column

Step-10-add-a-COUNTIF-formula

*chevron_right*
## Comments

## New Comment