Excel training
First written: Feb-2024
last changed Mar-2024
last changed Mar-2024
Utilising binary computed cells
Here we are going to utilise the previously computed field in order to take the data to the next step
To do this we are going to add a new column (F) with a label of Latest Salaries to multiple the Ind column values by those in the Daily Rate column
- In
F2add a new formula=E2*C2and drag this down toE21
- Add a column heading reading
Latest Salariesand format it using the paintbrush icon - Click on the column header for `F, then move the mouse to close to the right of the column header cell so that the mouse icon becomes

- Then double click on the mouse position so that the column becomes wide enough to show the contents of all cells (in this case wide enough for the whole column heading to be visible)
chevron_leftStep-10-add-a-COUNTIF-formula
Step-12-applying-Conditional-Formattingchevron_right
Comments
New Comment