I found a family that had formulas to calculate plumbing fixtures, but it was based on 2012 IBC. I was updating the formulas for the latest California code but don't seem to be getting the correct result. The women's count is 150, so it should use 4-(150/200) which equals 3.75, but it's showing -5.
Can someone help me pinpoint where the issue is?
Solved! Go to Solution.
Solved by ToanDN. Go to Solution.
Solved by ToanDN. Go to Solution.
Your < and > are wrong in the formula below, they should be reversed.
if(Women > 25, (1 - (Women / 25)), if(and(Women < 25, Women > 50), (2 - (Women / 50)), if(and(Women < 50, Women > 100), (3 - (Women / 100)), if(and(Women < 100, Women > 200), (4 - (Women / 200)), if(and(Women < 200, Women > 300), (6 - (Women / 300)), 0)))))
After reversing > and <:
Can't find what you're looking for? Ask the community or share your knowledge.