I was wondering if anyone can tell me if this is possible. I need to create
a formula based on the results of date in two separate fileds. Suppose I
have a field with 31064.47 and another with 28738. I wand to subtract the
2nd number from the first, then round the result to the nearest increment of
500. For example, 31064.47 subtract 28738 equals 2326.47. I would like to
round that result down to the nearest increment of 500 or 2000.

Can this be done, and how?