1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
4vir4ik [10]
3 years ago
10

An accountant needs to withhold 18% of income for taxes if the income is below $40,000, and 27% of income if the income is $40,0

00 or more. The income amount is in cell A1. Write a spreadsheet expression that would calculate the amount to withhold."
Mathematics
1 answer:
ser-zykov [4K]3 years ago
4 0

Answer:

=IF(A1<40000,(18%*I18),(27%*A1))

Step-by-step explanation:

The spreadsheet expression to  be used is the "IF" function. The "IF" function is one that returns a value based on the conditions stated thereafter in the spreadsheet formula. Like every spreadsheet function, this also starts with =

In the question given,

The value to be examined is in cell A1. if A1 is less than $40000 is written as A1<40000, is true,  the spreadsheets executes the next function stated as  (18%*I18) otherwise (which in this case can be interpreted as A1 greater than or equal to $40000), compute the next command as shown above;  (27%*A1)

The final parenthesis closes the command.

Hence the expression is IF(A1<40000,(18%*I18),(27%*A1)).

You might be interested in
What is the square root of 9​
taurus [48]
The square root of 9 is 3
3 0
3 years ago
Read 2 more answers
A farmer feeds her 4 horses 2 bales of hay. How many bales of hay would the farmer need in order to feed 20 horses?
xxMikexx [17]

Answer: 40 bales of hay

Step-by-step explanation:

5 0
3 years ago
Algebra II help I'm struggling
Dmitry [639]
Answer is B

total cost = $30 + 0.5 *(miles driven)
.................
7 0
3 years ago
A Ferris wheel can accommodate 40 people in 20 minutes. How many people
Montano1993 [528]

Answer:

360 people in 3 hours. 120 people per hour.

Step-by-step explanation:

How many times do 20 minutes go into 3 hours?

Well, 60 min. ÷ 20 min. = 3

So, 3 x 3 = 9

So 40 people went on the ride each 20 minutes. And there are (3) 20 minutes in every hour.

So 3 hours would be 9 x 40 = 360

120 people per hour because 40 x 3 = 120

and 20 minutes (3) times equals 1 hour.

6 0
2 years ago
How do you know that 5, 7, 8, 9, 10, and 11 are not factors of 12?
Mrrafil [7]

Answer :

Factors of 12 are

1  \times 12 \\ 2  \times  6 \\ 3  \times  4.

  1. 5 multiplied by any number can never give 12 . Multiples of 5 are
  2. 5 \: 10 \: 15 \: 20
  3. 7 multiples are
  4. 7 \: 14 \: 21
  5. Same applies for all the listed numbers
6 0
3 years ago
Other questions:
  • 12 buses bring a total of 420 people to the Alharbra in Granada, Spain. Each bus carries the same number of people. How many peo
    15·1 answer
  • Based on the given information, what can you conclude, and why? (PLEASE HELP!)
    8·1 answer
  • If you were to use the substitution method to solve the following system, choose the new equation after the expression equivalen
    12·1 answer
  • Please help asap!!!!!! quadratic functions 50 points
    12·1 answer
  • Help me plzzzzzzzzzzzzzzzz
    14·1 answer
  • A fair coin is tossed three times in succession. The set of equally likely outcomes is {HHH, HHT, HTH, THH, HTT, THT, TTH, TTT}.
    5·1 answer
  • Find atleast 3 solutions for the following linear equation in two variables:2x + 3y = 4​
    12·1 answer
  • The diameter of a circle is 6 in. Find its area to the nearest tenth.
    8·1 answer
  • PLEASE HELP, DUE SOON!! Your teacher is giving a test. The test will have 40
    10·2 answers
  • B - 8 = 9<br> ---------------
    5·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!