OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topic VLOOKUPsAdvanced Topics Pivot Tables
Excel training
First written: Feb-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

  1. 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)

  2. 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).

  3. 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