ExcelBanter - If Formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Formula? (https://www.excelbanter.com/excel-discussion-misc-queries/251394-if-formula.html)

Liz

If Formula?

I am looking for a formula that will give me a recommended headcount number
based on the following data.

store a is 50% effective with 6 people
store b is 75% effective with 4 people

the goal is to be 75% effective

what formula would i use where it would show me to reduce headcount by 2 in
store a so they are 75% effective?

Jacob Skaria

If Formula?

=(6/75%)*50%

--
Jacob

"Liz" wrote:

I am looking for a formula that will give me a recommended headcount number
based on the following data.

store a is 50% effective with 6 people
store b is 75% effective with 4 people

the goal is to be 75% effective

what formula would i use where it would show me to reduce headcount by 2 in
store a so they are 75% effective?

All times are GMT +1. The time now is 02:38 PM.