abraham3arroyo abraham3arroyo
  • 07-04-2021
  • Computers and Technology
contestada

If D3=30 and D4=20, what is the result of the function
=IF(D4 D3, D3-D4, "FULL")?
0-10
O Unknown
O 10
O Full

Respuesta :

MrRoyal
MrRoyal MrRoyal
  • 12-04-2021

Answer:

c. 10

Explanation:

Given

[tex]D3 = 30[/tex]

[tex]D4 = 20[/tex]

Required

The result of: [tex]=IF(D4 < D3,D3-D4,"FULL")[/tex]

First, the condition D4 < D3 is tested.

[tex]D4 < D3 = 20 < 30[/tex]

Since 20 < 30, then:

[tex]D4 < D3 = True[/tex]

The condition is true, so:

D3 - D4 will be executed.

[tex]D3 - D4 = 30 - 20[/tex]

[tex]D3 - D4 = 10[/tex]

Hence, the result of the function is 10

Answer Link

Otras preguntas

The Chicago Mercantile Exchange has announced the introduction of a financial instrument that is based on rainfall in the state of Illinois. The standard agreem
All common nouns begin with a capital letter. a. True b. False
4. Which of the for of the followig is not a pure substance? a. element c. compound b. molecule d. mixture
nitrogen-fixing bacteria can convert ammonia into nitrogen?
I need to know what the central idea is for the article of McDonald’s to test plastic-straw alternatives in U.S later this year
where is the major storage space for our biosphere’s nitrogen
Exercise 11-5A Determine proper classification (LO11-1) Analyze each of the four transactions Ernie’s Electronics had with Bert’s Bargain House from the perspec
What is a scale factor?
what profession did Luther's father want him to pursue​
Pediatricians will measure and track the growth of an infant’s weight and length to be sure the baby is thriving and growing properly. The growth of baby girl G