Formula assitance needed

C

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?
 
M

Mike H

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
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top