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, 22.06.2019 21:00
Kirk found a local community college with a two-year program and he is comparing the cost with that of an out-of-state two-year school. what is the expected total cost for one year at the local community college if kirk lives at home? what is the expected total cost for one year at the out-of-state school if kirk lives on campus?
Answers: 2
question
Computers and Technology, 23.06.2019 00:30
Which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard
Answers: 2
question
Computers and Technology, 23.06.2019 03:10
Fill in the following program so that it will correctly calculate the price of the orange juice the user is buying based on the buy one get one sale.#include //main functionint main() { int cartons; float price, total; //prompt user for input information printf("what is the cost of one container of oj in dollars? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & price); printf("how many containers are you buying? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & cartons); if ( [ select ] ["cartons / 2", "cartons % 1", "cartons % 2", "cartons % price", "cartons / price", "cartons / total"] [ select ] ["=", "==", "! =", "< =", "> =", "< "] 0) total = [ select ] ["price * cartons", "cartons * price / 2 + price", "(cartons / 2) * price", "cartons / (2.0 * price)", "(cartons / 2.0) * price + price", "((cartons / 2) * price) + price"] ; else total = ((cartons / 2) * price) + price; printf("the total cost is $%.2f.\n", total); return 0; }
Answers: 2
question
Computers and Technology, 23.06.2019 09:30
Given a link with a maximum transmission rate of 32.8 mbps. only two computers, x and y, wish to transmit starting at time t = 0 seconds. computer x sends filex (4 mib) and computer y sends filey (244 kib), both starting at time t = 0. statistical multiplexing is used, with details as follows packet payload size = 1000 bytes packet header size = 24 bytes (overhead) ignore processing and queueing delays assume partial packets (packets consisting of less than 1000 bytes of data) are padded so that they are the same size as full packets. assume continuous alternating-packet transmission. computer x gets the transmission medium first. at what time (t = ? ) would filey finish transmitting? give answer in milliseconds, without units, and round to one decimal places (e.g. for an answer of 0.013777 seconds you would enter "13.8" without the quotes)
Answers: 3
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, 09.12.2021 06:50
question
Biology, 09.12.2021 06:50
question
Social Studies, 09.12.2021 06:50
question
Mathematics, 09.12.2021 06:50
question
Mathematics, 09.12.2021 06:50
question
Mathematics, 09.12.2021 06:50
question
English, 09.12.2021 06:50