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

9/2 as a mixed number
Which statement explains how the creation of the Peace Corps related to the Cold War? A. President Kennedy wanted to spread a positive image of the United State
Which of the following areas has the lowest population density? Papua New Guinea Fiji Islands Solomon Islands Antarctica
Find the percent change from 60 to 96
Which are the cell organelles that participate in cell division and in the formation of cillia and flagella of some eukaryotic cells?
You have learned about the rise and fall of the Soviet Union and its influence in Europe. Who or what was responsible for the end of communism in Europe?
Would a worm,a rabbit,or a butterfly most likely leave a fossil remains? Explain
Richard practiced each of 3 piano solos for 5/12 hour. Expressed in simplest form, how long did he practice in all.
The Native Americans were mad at the British because
what is another word for hooked?