Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chelle19 Chelle19 is offline
external usenet poster
 
Posts: 3
Default Formula Help

Hi All -

I am trying to figure out how to populate a different output by entering in a
different value. For instance, there are employees that can work 20 hours, 25
hours or 30 hours. I need to formulate this so if someone puts in 20 hours it
will take the number of people working 20 hours and process it into an FTE
(full time equivalent). Meaning, if I hire 100 people to work 20 hours per
week, but need to figure out how many people that would be, I, of course, can
figure it to be 200 people to equal out to FTE count. So, if I need 200
people, I want them to work x hours then it will tell me how many people that
translates to in FTEs. Hope that make sense?

Thanks!