Formula assitance needed

[Codeman]

Cell C13’s formula is: =SUM(ROUNDUP(B13/C9,0))

Where B13 is occupant load in a numerical value and C9 is the number of
people allowed for a fixture in a numerical value.

What I need now is when the occupant load is 50 or less Cell C13 should read
“Uni-sex†and not a number and if the occupant load is over 51 then the
numerical answer would appear in Cell C13. The quotation marks do not have
to appear around Uni-sex with the answer.

The numerical number in C9 is 500 and will not change. The numerical number
in B13 will change as it is the answer from another cell.

Can someone assist me with this formula?

 

[T. Valko]

Try this:

=IF(COUNT(C9,B13)<2,"",IF(B13<=50,"Uni-sex",ROUNDUP(B13/C9,0)))

 

[Codeman]

Thank you all,

I will have to get back to you all on this one. I used the forumlas
provided but the result affected another cell I was trying to work with also.
I will have to rethink what I am trying to do. I am sure when I develope a
almost solution I will need assistance again.

Will get back later on this but I am sure it will be another post.

Thanks again.