Question

An accountant needs to withhold 15% of income for taxes if the income is below $40,000, and 23% of income if the income is $40,000 or more. The income amount is in cell A1. Write a spreadsheet expression that would calculate the amount to withhold.

Answer 1

=if(A1<40000,.15*A1,if(A1

Explanation:

>=4000,.23*A1))