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.
Share the family here.
Toan Nguyen
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
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 <:
Toan Nguyen
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Format the label's units. Example to set it to 6 decimal places.
Toan Nguyen
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Can't find what you're looking for? Ask the community or share your knowledge.