ceiling/floor worksheet function

[Guest]

hi folks -
I currently use an Excel worksheet function that allows me to take a value,
write an IF statement against that value that outputs a new value using the
ceiling/floor MS Excel worksheet function. IF(CEILING(#val,500) - #val)>390,
FLOOR(#val,500), CEILING(#val,500)) Basically, if my #val = 1700, the
equation would result in a new value of 2000 using the above. The only
function in an Access query I see is ROUND or ROUNDTONEAREST - any help is
appreciated.

 

[Allen Browne]

The nearest things in Access would be Partition, Switch, Choose, or a bunch
if nested IIf()s.

In a database, you place this kind of data in tables and look them up.
Tom Ellison has an explanation here:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html