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, 23.06.2019 19:00
This question involves a class named textfile that represents a text file. public class textfile { private string filename; private string filename; private arraylist words; // constructors not shown // postcondition: returns the number of bytes in this file public int filesize() { } // precondition: 0 < = index < words.size() // postcondition: removes numwords words from the words arraylist beginning at // index. public void deletewords(int index, int numwords) { } // precondition: 0 < = index < = words.size() // postcondition: adds elements from newwords array to words arraylist beginning // at index. pub lic voidaddwords(int index, string[] newwords) { } // other methods not shown } complete the filesize() method. the filesize() is computed in bytes. in a text file, each character in each word counts as one byte. in addition, there is a space in between each word in the words arraylist, and each of those spaces also counts as one byte. for example, suppose the words arraylist stores the following words: { mary had a little lamb; its fleece was white as snow. } the filesize() method would compute 4 + 3 + 1 + 6 + 5 + 4 + 6 + 3 + 5 + 2 + 5 as the sum of the lengths of each string in the arraylist. the value returned would be this sum plus 10, because there would also be 10 spaces in between the 11 words. complete the filesize() method below: // postcondition: returns the number of bytes in this file public int filesize() { }
Answers: 1
question
Computers and Technology, 24.06.2019 05:50
What all vehicles has tesla inc. created over the years
Answers: 3
question
Computers and Technology, 24.06.2019 13:30
Which of the following is not a “fatal four” event?
Answers: 2
question
Computers and Technology, 24.06.2019 21:30
How do i copy and paste equations and pictures like math graphs, to post on this site to get my questions answered?
Answers: 2
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, 12.03.2020 05:27
Questions on the website: 13722362