Please calculate the Bonus Amount for each row according to the Commission Table on the right side. Once with IF statements Sale Amount 100,000 250,100 32,000 502 542,000 56,800 698,300 5,550,000 1,023,400 152,000 52,000 Bonus Amount (IF) Example 250.1 Commission Table 250.10 Sale Amount Rate 0.00% 10,000 0.01% 100,000 0.10% 500,000 0.40%