averaging data
You didn't say if these numbers were calculated. If the numbers are
calculated Excel will not display a number like 1.9000 unless it's formatted
to display all the decimal places but the true underlying value of the cell
is 1.9.
Try this:
=IF(MOD(A2,1),IF(LEN(MOD(A2,1))<6,A2,IF(MOD(MID(MO D(A2,1),5,1)+0,2),ROUND(A2,3),TRUNC(A2,3))),A2)
Biff
"James" wrote in message
...
the numbers would range from about .50000 to 1.9000
"T. Valko" wrote:
This sounds like a nightmare!
1.5245
1.5255
Are these values calculated? If so, the true value can be more than 4
decimal places. I was able to do it using a rather ugly IF formula based
on
every number being set at 4 decimal places or being integers. Do you have
values like:
10.2
0.522
150.009
Biff
"James" wrote in message
...
When averaging data in EXCEL I need to round up at 5 or above only if
the
preceding number is odd, if it is even, the number is not rounded up.
Example, 1.5245 rounds to 1.524, 1.5255 rounds up to 1.526. Is it
possible
to
do this in EXCEL?
|