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
F2
add a new formula=E2*C2
and drag this down toE21
- Add a column heading reading
Latest Salaries
and 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