Microsoft Office Forums - View Single Post - Rounding to nearest 0.25

Thread: Rounding to nearest 0.25

View Single Post

Old

10-27-2015, 03:16 AM

Guloluseus Guloluseus is offline

Guloluseus is offline

Guloluseus uses Windows 7 64bit

Windows 7 64bit Guloluseus uses Office 2010 32bit

Guloluseus uses Office 2010 32bit

Office 2010 32bit

Competent Performer

The original poster

Join Date: Mar 2013

Posts: 168

Guloluseus is on a distinguished road

Default

I just solved this- suffered from a case of number blindness at the last hurdle

I was trying to use mround but it rounded to the nearest 0.25- I used an IF statement so that if the new value was less than the original it moved it up a band.

Yay!

Reply With Quote