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?

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?

Try this:

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

--
Biff
Microsoft Excel MVP


"Codeman" wrote in message
...
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?

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.