"The correct answer is 36. Key Points The FLOOR function in MS Excel is used for rounding down a given number to the nearest multiple of the given significance. The syntax of FLOOR is '=FLOOR(number, significance)'. The CEILING function in MS Excel is used for used for rounding up a given number to the nearest multiple of the given significance. The syntax of CEILING is '=CEILING(number, significance)'. Here, the given equation is =CEILING(19,4)+ FLOOR(19,4). '()' is the first bracket referred to as a function bracket. The '+' is used as an addition operator. ',' is used for separating the cells. In the =CEILING(19,4)+ FLOOR(19,4) function, CEILING(19,4) will return 20 and FLOOR(19,4) will return 16. 20 and 16 are the nearest multiple of 4. Thus the correct answer is 36."

John wrote:

I am looking for a single function that will do EITHER a ROUNDUP or ROUNDOWN based on the value.  (i.e. on a scale from 1-10, if the value is 1-4, I want to round the value down; if value is 5-10, I want to round the value up). Is there such a function that will do this in a single calculation?

That's the very definition of ROUND.  But your example is ambiguous insofar as it is unclear what digit you are talking about rounding.

If you want 1.4 in A1 to round to 1 and 1.5 to round to 2, use ROUND(A1,0).

If you want 14 to round to 10 and 15 to round to 20, use ROUND(A1,-1).

See the ROUND help page for more details.

---

PS:  For future reference, when you have a question, start a new discussion instead of piggybacking an old discussion, much less a discusion marked "answer".

First, usually no two questions are every identical in all details.  So your specifics might require a completely different direction.

Second, some helpful people might never see your new "response" because they do not look at discussions marked "answer".

Finally, since you are not the original poster, you have no way to mark responses to your question as "answer".

u/Nitropanel - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.