Thanks David and others.

I overcame my problem, by adding an extra row, which used the ROUND function
with a reference to the result in the cells where I was having problems
displaying the result that I expected to see.

Regards

Dartanion

"David Biddulph" wrote:

Perhaps I've misunderstood your question, but please go back and read Excel
help again.

ROUNDDOWN rounds down.
ROUNDUP rounds up.
ROUND rounds to the nearest.

The help topic "Round a number" gives detailed hints for a variety of
different rounding methods (including rounding to the nearest). For each
function in Excel help there is usually a "See also" link for similar and
related topics, and they usually give examples of the function in operation.
--
David Biddulph

"dartanion" wrote in message
...
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.