What is the advantage of MROUND(A1,1) compared with ROUND(A1,0), Mike?
--
David Biddulph

"Mike H" wrote in message
...
If your logic is followed precisley then 0.49 becomes zero and I assume
you
don't want this so up to 0.99 rounds to 1 and thereafter follows your
rules

=IF(A10,MAX(mround(A1,1),1),"")

If that assumption is incorrect simply use

=mround(a1,1)

Mike

"dartanion" wrote:

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.