A
Amy E. Baggott
We have an incentive program that gives exhibitors a 30% discount on services
up to a maximum discount amount that is determined by their booth size. We
want to send a letter to them showing each of them what their maximum
discount is and how much they would have to spend to get it. On more than a
few records, the "must spend" amount trails off into odd cents. I have a
hunch my boss is going to want me to round it to the nearest $100. Does the
Round function round to the nearest 100 or would I have to construct some
sort of expression to do it the long way?
up to a maximum discount amount that is determined by their booth size. We
want to send a letter to them showing each of them what their maximum
discount is and how much they would have to spend to get it. On more than a
few records, the "must spend" amount trails off into odd cents. I have a
hunch my boss is going to want me to round it to the nearest $100. Does the
Round function round to the nearest 100 or would I have to construct some
sort of expression to do it the long way?