_almost_ got my building space/area calculator working but am getting a #/DIV 0! error (legitimately) when dividing an Area by an occupancy of 0. The zero is coming from ='Space'.'SpaceOccupancyRequirements_AreaPerOccupant'
Trying to avoid that by :
=IF((L6=0), 0, F6/L6)
Somehow that still gives the div/0 error when there shouldnt be any division happening!? Ive tried adding ' marks to the zero to no avail.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
techdef
_almost_ got my building space/area calculator working but am getting a #/DIV 0! error (legitimately) when dividing an Area by an occupancy of 0. The zero is coming from ='Space'.'SpaceOccupancyRequirements_AreaPerOccupant'
Trying to avoid that by :
=IF((L6=0), 0, F6/L6)
Somehow that still gives the div/0 error when there shouldnt be any division happening!? Ive tried adding ' marks to the zero to no avail.
Link to comment
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.