Thread: If Formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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?