Ensure that you update the cell references, like C9 and B9, to correspond to the actual cells that contain the salary and job title information for each manager in your spreadsheet.
To apply a conditional salary increase in your spreadsheet, adhere to the following sequence in cell L9:
1. Click on cell L9 to make it active.
2. Initiate the IF statement by inputting "=IF(" into L9.
3. Insert the nested AND function within the IF statement by typing "AND(" after the IF function's opening parenthesis.
4. Incorporate the first criterion within the AND function, ensuring it checks if the salary is below $90,000. Adapt "salary" to the actual cell that holds the manager's salary, such as "C9 < $90,000" if cell C9 contains this data.
5. Follow the first criterion with a comma, then set the second criterion to verify the job title is 'manager'. Modify "title" to the cell that contains this information, for instance "B9 = "manager"" if it's located in cell B9.
6. Finalize the AND function by typing "))".
7. Post the AND function's closing parenthesis, insert a comma, then key in the true condition outcome, which is the $90,000 salary increment, by typing "$90,000".
8. After the true value, add another comma and enter the false condition outcome, which is a zero increase, by typing "0".
9. Conclude the IF statement with a closing parenthesis ")".
10. Execute the formula by pressing Enter.
With this procedure, cell L9 will calculate and exhibit a $90,000 hike for any manager earning below that amount, while showing no increase for others. Adjust cell references such as C9 and B9 to align with the actual data positions in your spreadsheet.