There is an alternative to CEILING using a little math and ROUNDUP.

=ROUNDUP(A1/2, 0)*2

It may be important to note how CEILING works with negative numbers. CEILING always rounds to the numerically larger number.

For the following examples, assume 3 in A1 and -3 in A2.

=CEILING(A1, 2)         'rounds up to +4
=CEILING(A2, 2)         'rounds up to -2

On the other hand, ROUNDUP always rounds away from zero.

=ROUNDUP(A1/2, 0)*2      'rounds up to +4
=ROUNDUP(A2/2, 0)*2      'rounds away from zero to -4

Conversely, ROUNDDOWN and FLOOR (the inverse of ROUNDUP and CEILING) operate in the same manner by in the opposite 'direction'.

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".