I need a formula for excel that will round down an odd number in a cell to
the next even number.

I also need a formula example: if a number cell is =a number range (say, 1
to 1-1/2), the new cell should contain a message (such as:"A", "B", "BBC",
etc)
--
confused