twistedchickie
New Member
- Joined
- Apr 27, 2002
- Messages
- 7
We are attempting to streamline our scheduling with formulating estimated calls into a spreadsheet(cheap company won't buy me scheduling software). What I am wanting to do is to take my orders * 1.5 which I got that far. Now I want to take the result and have it enter a value for instance if I have 24 orders * 1.5 would be 38 estimated calls and then pick a value like listed below
so something like if x is <0 but >/=25 then 02, if <26 but >=100 then 07
calls people needed
0-25 02
26-100 07
101-150 09
151-200 11
Am I wishing for the impossible or can this happen?
Thanks,
Char
so something like if x is <0 but >/=25 then 02, if <26 but >=100 then 07
calls people needed
0-25 02
26-100 07
101-150 09
151-200 11
Am I wishing for the impossible or can this happen?
Thanks,
Char