I use a formula round('value'/365,2)*365 to round a dollar amount, which works great but with more people starting to participate, I'm wondering if I can add a script to either:
1. highlight a "non-rounded" value
2. or better yet - fix the entry; example: someone enters $350, the code would correct it to the nearest "rounded value" or $368.65.
1. highlight a "non-rounded" value
2. or better yet - fix the entry; example: someone enters $350, the code would correct it to the nearest "rounded value" or $368.65.