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
44,975 views
16 votes
16 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 Humbert
by
2.7k points

1 Answer

25 votes
25 votes

Answer:

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

Explanation:

>=4000,.23*A1))

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

1.6m questions

2.0m answers

Other Questions

Can anybody tell me what’s going on here?
Evalute 8a -1+0.5b when a =1/4 and b= 10 how dose this work i need help..
PLZ needed now plz URGENT!
HELP PLEASE, I NEED THE ANSWER QUICKLY
Yall help me out please
Link Copied!