Hi David,

In my question, I gave two possibilities, above and below .5
ROUND gives me one or the other and I am greedy and want excel to look at
the answer and decide which way to go up or down.
If I have missed something in EXCEL help on the subject of ROUND, please can
you point me in the right direction.

Thanks

"David Biddulph" wrote:

Why not try typing the word ROUND into Excel help, and see what it tells
you?
--
David Biddulph

"dartanion" wrote in message
...
Is there a formula that will do the following;
The result of a formula can be a whole number plus two decimal places, and
I
want a row of data to do the following - If the answer is between .00 and
.49
then round down, and if it is between .50 and .99 round up. I can do each
individually, but not both automatically in the same formula.