Question: I need a formula that will take the salary compare it to the mid column in the first chart and produce a grade in an

I need a formula that will take the salary compare it to the mid column in the first chart and produce a grade in an the empty grade space. I tried to do vlookup but it produces N/A.
I need a formula that will take the salary
\begin{tabular}{|c|c|} \hline A & B \\ \hline Mid & Grade \\ \hline$188,298 & A \\ \hline$169,495 & B \\ \hline$150,693 & C \\ \hline$135,569 & D \\ \hline$120,445 & E \\ \hline$108,401 & F \\ \hline$96,356 & G \\ \hline$86,737 & H \\ \hline$77,118 & I \\ \hline$69,351 & J \\ \hline$61,585 & K \\ \hline$55,454 & L \\ \hline$49,323 & M \\ \hline$44,418 & N \\ \hline$39,513 & O \\ \hline$35,561 & P \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!