| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assitance needed
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GP Formula Needed | Excel Discussion (Misc queries) | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| Assitance W/ An If/Then formula | Excel Discussion (Misc queries) | |||
| IF AND Formula Help Needed | Excel Discussion (Misc queries) | |||
| Formula Needed! | Excel Discussion (Misc queries) | |||
Threaded Mode
