I have designed a calculator to work out the number of people required to do certain tasks based on a fixed rate.
When I run the calculator it gives a value to 1 decimal place
It is acceptable to ask someone to do more than the work of 1.2 people.
How do I round at a value other than 0.5 but dependent upon what the whole number is.
I.e.
1.2 and less becomes 1, 1.3 and above becomes 2;
2.4 and less becomes 2, 2.5 and above becomes 3;
3.6 and less becomes 3 but 3.7 and above becomes 4;
4.8 and less becomes 4, 4.9 becomes 5
Obviously there after I want it just to round down
sorry for the complex explanation
When I run the calculator it gives a value to 1 decimal place
It is acceptable to ask someone to do more than the work of 1.2 people.
How do I round at a value other than 0.5 but dependent upon what the whole number is.
I.e.
1.2 and less becomes 1, 1.3 and above becomes 2;
2.4 and less becomes 2, 2.5 and above becomes 3;
3.6 and less becomes 3 but 3.7 and above becomes 4;
4.8 and less becomes 4, 4.9 becomes 5
Obviously there after I want it just to round down
sorry for the complex explanation