Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need help on completing a formula in excel.
Problem: The resulting answer must account for an egress width answer based on a known occupant load and number of Exits. With an occupant load of 49 or less the egress width cannot be less than 36-inches and the number of exits would be one or two. With an occupant load of 50 or more the egress width must be 44-inches minimum but could be more and the number of exits would be two or more. Egress width is occupant load times egress factor all divided by number of Exits. The egress factor, occupant loads and number of Exits will be in cells on the spread sheet. The egress width in inches will require rounding up to the next full number (no decimals). I have developed the formula so far as rounding up but I need to modify the formula to the limits mentioned in the first paragraph above. Examples: (49 x 0.20)/2 = 4.9 (rounded up the value is 5). However, the minimum must be 36-inches. (312 x 0.20)/2 = 31.2 (rounded up the value is 32). However, the minimum must be 44-inches since the occupant load is 50 or more. (958 x 0.20)/3 = 63.9 (rounded up the value is 64). The minimum of 44 is exceeded and the calculated value of 64 must be used. Cell G5 - Occupant load; 312-people Cell C47 - Egress Factor; 0.20 Cell H5 - Number of Exits; 2 The formula I have so far is below; =ROUNDUP(((G5*C47)/H5),1) I did find one thing in my formula that I also need correction. On the round up function I need the round up to always be one if the resultant answer is less than 1. But that may not bean issue if the 36 inches is worked in the formula as a minimum. (2 x 0.15)/1 = 0.3 comes out as 0 using my formula. However, if the occupant load is 3 then the answer rounds to 1. 0.15 is another egress factor I can use in buildings with a sprinkler system. Is there a way to make the formula never be below 36 when the occupant load is 49 or less, never be below 44 when the occupant load is 50 or more and when the occupant load is large enough to require the egress width to be larger than 44 it will show the values above 44? Any help would be appreciated. Codeman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What are the calcs in PMT | Excel Worksheet Functions | |||
Time calcs | Excel Discussion (Misc queries) | |||
Dates/Amounts calcs | Excel Worksheet Functions | |||
What is procedure to exit formula auditing mode? | Excel Discussion (Misc queries) | |||
Time Calcs | Excel Worksheet Functions |