Go to cell L$9$ and

insert an IF function

with a nested AND

function to display

Raise salary to $$90K$

for all managers who

earn a salary less

than $$90,000$ and No

raise for anyone who

does not fit the

criteria.

Use the fill handle to copy the

function down, populating the rest

of the Raise Status column.

Select Fill Without Formatting to

preserve the existing formatting.