Register
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
231,969 views
5 votes
5 votes
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.

User Ravistm
by
2.9k points

1 Answer

2 votes
2 votes

Answer:

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

Explanation:

>=4000,.23*A1))

User Rafaljusiak
by
3.0k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

3.3m questions

4.2m answers

Other Questions

A study was completed in Florida. In southern Florida, the study involved 3,000 patients; 54% of them experienced flulike symptoms during the same month. The study had a margin of error of 1.8%. What does
Can someone help me plz I have to Turn 27/9 in simplest
The sanchez family goes out for dinner, and the price of the meals is $60. The sales tax on the Meals is 7 percent, and they also want to leave a 15 percent tip. What is the total cost of the meal? Analyze
Simplify: 10 ÷ [(5 + 2) − 5]
WHAT IS 33 TIMES 5 TELL ME THE ANWER
Link Copied!