Formula to show percentage difference for one column and then items needed based on result

Looking at the spreadsheet you will see on the tab titled "DATA" at the end the far right of the spreadsheet. Looking at the last entry in green, You will see column "J" is showing 1.76% of the required 5.3% of this job class to total employee. Column "P" is showing they are down 3.54% of the recommended 5.3%. Column "Q" says we need to have 1068 employees for this job class based on the 5.3% mark.

Which is correct, however some of the items in column "Q" are showing we still need to hire when we are well over the 5.3% recommendation.

What did I do wrong when doing the calculation?

Thanks

Q does not show how many need to hired but simply numbers required to meet your target of 5.3% of group

try this in Q

=MAX(0,D6*O6-E6)

you will get 0 if sufficient staff(overstaffed) are in place.

and don't need SUM (..) round many of your formulae ..

=O6-J6 will suffice

hi
...........