Try another version of this question Get help: Box 1: Enter your answer as letters. Examples: A B C, linear, a cat
An accountant needs to withhold 18% of income for taxes if the income is below $20,000, and 27% of income if the income is $20,000 or more. The income amount is in cell
A1
. Write a spreadsheet expression that would calculate the amount to withhold.
=IF(A1<20000, 0.18*A1, 0.27*A1)