subject
Computers and Technology, 20.01.2021 01:00 mikego5

PLEASE HELP MEE! Suppose you are working on your taxes using a Microsoft Excel spreadsheet. Cell B3 shows the total amount of income tax you paid. Cell B2 shows the total amount of tax for which you are responsible.

You want to write a formula that looks to see if the amount that you paid is greater than the amount that you were responsible for.

If it is, then subtract the amount you were responsible from the amount you paid and round this difference to the nearest whole number.
Otherwise, display zero.
There are two correct answers, but you only need to select one of them.

A. =IF(B3>B2, ROUND(B3 – B2, 0), 0)

B. =IF(B3>B2, ROUND(B2 – B3, 0), 0)

C. =IF(B2>B3, ROUND(B3 – B2, 0), 0)

D. =ROUND(IF(B3>B2, B3 – B2, 0), 0)

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 17:20
Q-3 a technician is setting up a computer lab. computers on the same subnet need to communicate with eachother peer to peer communication,a. hardware firewallb. proxy serverc. software firewalld. gre tunneling
Answers: 3
question
Computers and Technology, 22.06.2019 16:30
What type of file does a cookie place on web site visitors' computers so that web site managers can customize their sites to their visitors' preferences?
Answers: 1
question
Computers and Technology, 22.06.2019 17:00
Acase study allows a more detailed look at the life of a single subject than any other study.
Answers: 3
question
Computers and Technology, 22.06.2019 20:00
Which type of file can be used to import data into a spreadsheet?
Answers: 1
You know the right answer?
PLEASE HELP MEE! Suppose you are working on your taxes using a Microsoft Excel spreadsheet. Cell B3...
Questions
question
Mathematics, 17.12.2019 06:31
question
Social Studies, 17.12.2019 06:31
question
Mathematics, 17.12.2019 06:31
Questions on the website: 13722360