C

#### Codeman

Total fixture count is say 7 (cells B5 divided by F8 on my spreadsheet

rounded up)

One cell (F18) is to show 50% of the total fixture count rounded up which

would be 4.

Another cell (F19) is to show the answer of say 7 â€“ 4 = 3. F19â€™s answer is

never to be less than 1.

The numerical values in the cells change with the occupant load and the

numbers provided are for reference only.

Cell F18 formula is: =SUM(ROUNDUP((B5/F8)*50%,0)) This formula provides the

total fixture count from cells B5Ã·F8 and then takes 50% of the answer and

rounds up.

Cell F19 is the cell I am trying to complete. Its answer should never be

less than 1 and F19â€™s answer added to F18â€™s answer should be always equal the

Total fixture count (B5Ã·F8 rounded up). However, if the total fixture count

is only 1 then F19 should also have a 1. F18 will always have at least 1 as

an answer as will the total fixture count.

Cell F19 will be the required wheel chair accessible drinking fountains.

You always have to have one low drinking fountain and one higher drinking

fountain even if only one drinking fountain is required for the occupant load.

Cell F18 will be the required high drinking fountains.

Can anyone help me with the formula to be in Cell F19?