I am working on getting occupancy loads. I can get the schedule to round to the nearest whole number as long as it follows the rule 1.1 =1 and 1.6 = 2. But the code says anything over 1.00 is to round up to the next higher number so 1.1 = 2 and so on.
Here is the struggle I have been having. I can get the .3 and .7 to round to 1 but I can get anything like 1.1 to round up to 2 or the 22.23 to round to 23. The formula I have in the calculated value is as follows:
if(round(Area / Occupancy Load Factor) / 1 ^ 2 < 1, 1, (Area / Occupancy Load Factor) / 1 ^ 2)
This works great on rounding to 1 and using the 1.1 =1 method.
What would I need to add to or modify to get the formula above to round the .33 to 1 and the 1.1's and the 22.23 to round up to the next highest number?
I am very rusty at IF statements and need some guidance.
Thank you for the help.