Please find the following Excel form for calculating the bonus as required. Please ensure the equation is duplicated even so, with the sign "=." It is possible to insert this formula into cell L12. Then cut/paste the cell into other L12:L39 cells.
The mixed microbial reference here is used in L7, L8, and L9 so these cell references are not moved whenever the formula is copied to L12:L39.
Please verify that whenever the copy has also been copied, the cell formula appears beneath in each cell.
Please find the following Excel form for calculating the bonus as required. Please ensure the equation is duplicated even so, with the sign "=." It is possible to insert this formula into cell L12. Then cut/paste the cell into other L12:L39 cells.
The mixed microbial reference here is used in L7, L8, and L9 so these cell references are not moved whenever the formula is copied to L12:L39.
Please verify that whenever the copy has also been copied, the cell formula appears beneath in each cell.