Mathematics, 22.01.2021 01:00, netflixacc0107

Please help!! 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)

Answers: 1

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 15:30, squawk1738

Given the box plot, will the mean or the median provide a better description of the center? box plot with min at 10.5, q1 at 11.5, median at 12.5, q3 at 13.5, max at 15

Answers: 2

continue

Mathematics, 21.06.2019 16:40, cthompson1107

The table shows the total distance that myra runs over different time periods. which describes myra’s distance as time increases? increasing decreasing zero constant

Answers: 2

continue

Mathematics, 21.06.2019 19:30, matt2167

Two variables, x and y, vary inversely, and x=12 when y=4. what is the value of y when x=3?

Answers: 1

continue

Mathematics, 21.06.2019 20:30, velazquezemmy45

Aswimming pool measures 22ft by 12ft and is 4ft deep. if the pool is being filled at 2.5 cubic ft per minute, how long will it take to fill the pool?

Answers: 1

continue

Do you know the correct answer?

Please help!! Suppose you are working on your taxes using a Microsoft Excel spreadsheet. Cell B3 sh...