Quote:
Originally Posted by Gene Haines
I am trying to see if the VBA rounding function will round to even. As an example:
Cell A1:A6
2.45
2.75
2.89
2.67
2.56
2.32
Result from above
2.4
2.8
2.8
2.6
2.6
2.4
I cannot find anything online that will accomplish this. Does anyone know the code in VBA that may work?
Thank you
Gene Haines
|
Peter: Guy in work is a metallurgist and is using this type of rounding for chemical composition. He had asked me if I knew a way to do this. Of course I volunteered to help him out.
Thanks for your response
Gene