contestada

an accountant needs to withhold 21% of income for taxes if the income is below $40,000 and 26% 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 withhold.

Respuesta :

A spreadsheet expression=IF(A1<40000,(21%*I21),(26%*A1))

The "IF" function should be used in the spreadsheet expression. The "IF" function returns a value based on the criteria specified in the spreadsheet formula. This, like other spreadsheet functions, begins with =.In response to the question,

Cell A1 contains the value to be inspected. If A1 is smaller than $40000 (written as A140000), the spreadsheet performs the following function: (21%*I21). otherwise (which may be understood as A1 higher than or equal to $40000 in this example), calculate the following command as indicated above; (26%*A1).

The command is finished with the last parenthesis.

To  learn more about   spreadsheet expression from the given link:

https://brainly.com/question/10509036

#SPJ9

Otras preguntas