Hi Rick,

I am wondering if you can help me converting -434499.68 to -434600 and 8500.16 to 8400 and -99896.36 to -99900 and 372646.57 to 372600 using one formula.
I used 100*floor (x/100) and was able to convert 99896.36 to -99900 and 372646.57 to 372600 but not the other two.