I am setting up a table to automatically calculate plumbing fixtures based on occupancy count.
The problem I have is creating a formula for plumbing fixtures for B occupancy where toilets are required at 1 per 25 for the first 50 occupants and thereafter 1 per 50 occupants. (International Building Code)
A simple formula for 1 at 25 would be "value/25" whereby the value would be a cell content (occupancy number).
Taking this further with a formula like "(value-50)/50+(value/25)" works fine as long as the value (occupancy) is greater than 50.
If the value is less than 50 the first part of the formula (value-50)/50 creates a negative result.
Is there a way to convert a negative result of the first part of the formula to a 0 (zero)
I know this is possible in Excel with the "max" function