plumbing count formula issue

[Ian_H]

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?

[ToanDN]

Share the family here.

[Ian_H]

Here it is

[ToanDN · Accepted 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 <:

[Ian_H]

Thanks for catching that. I'm glad it's a simple fix, but I feel dumb for not catching that. lol

[Ian_H]

@ToanDN 

Is there a way to denote the number of decimal points you want in a number? 

In the screenshot you can see there is a number that is 6 decimals deep and one that is 3 decimals deep. I don't want it to round to 2 decimals. 

[ToanDN · Accepted solution]

Format the label's units.  Example to set it to 6 decimal places.

[Ian_H]

Thanks again