round up

[Rhubie]

Is is possible to round up to the nearest nickel - they do not round up the same - I'm not sure what I am doing different in Access - I read something that Access rounds as banker round up - not sure what that means - how do I get them to round the same?

In Access
BookPrice: Round((([PackPrice]/20)+5),1)
PackPrice = 801.25 - value is 45.10

In Excel


=MROUND(+K4/20+5,0.05)
K4 = 801.25 - value is 45.05

[orange]

From Allen Browne's site

Round to nearest 5 cents

To round to the nearest 5 cents, multiply the number by 20, round it, and divide by 20:
Round(20 * [MyField], 0) / 20