I don't pretend to unserstand your formula, with 500 in C9 it needs a
number 25000 in B13 to mahe the formula evaluate as 50

Try this

=IF(ROUNDUP(B13/C9,0)<=50,"Unisex",ROUNDUP(B13/C9,0))

Mike

On Wed, 4 Mar 2009 12:58:05 -0800, Codeman
wrote:

Cell C13s 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?