Associate
- Joined
- 22 Jan 2006
- Posts
- 460
basically need to get it to select an amount of staff to cover the amount of meals, and its choosing a lesser value, which is no good :s
any ideas?
-
Notice regarding image hosts and attachments. See here.
vlookup
- Thread starter willthepirate
- Start date
basically need to get it to select an amount of staff to cover the amount of meals, and its choosing a lesser value, which is no good :s
any ideas?
This is horrible really but for now it works with the silly examples i have done. Also assumed for example that even 1 meal above 9000 would need 6 staff. As well as of course that your data wont ever change as you will have to type more nested if's the more you put into it!
Must sleep now
Must sleep now