I am working on debugging my payroll calculator, and I want to have a variable rounded to the nearest 50, but not including 100.
For instance, I have the variable 23324.60, and I need a formula that equates to 23350.00.
This is to meet the following instruction on AR Tax Withholding calculation.
"Since the Net Taxable Income is less than 50,000, we will take the income to the $50 midrange of $23,350.00 (midrange of $23,300.00 and $23,400.00). "