angelina166034 angelina166034
  • 10-04-2018
  • Computers and Technology
contestada

14. If B3=10 and D5=8, what would the following function return? IF(B3>D5, "Closed", D5-B3) *

A. "Open"
B. "Closed"
C. -2
D. +2

Respuesta :

Rodiak
Rodiak Rodiak
  • 20-04-2018
IF function has three parts
IF (condition_to_check , return_if_true , return_if_false)

IF function first checks condition. If it is true it returns first result. Otherwise it returns second result.

Condition to check:
B3>D5
After inserting numbers we get:
10>8
This is correct so the first result will be returned.
The given IF function returns "Closed".
Answer Link
winklescaleb
winklescaleb winklescaleb
  • 01-03-2022

Answer:

closed

Explanation:

Answer Link

Otras preguntas

which statement best explains why time of day can be a factor that affects flexibility?A. circadian rhythm influences body temperature.B. coordination skills ar
Based on the figure below, what is the value of x?
Can some help me with this question plz asap
8% as a decimal???????????????????????????????
Estimate the unit rate to the nearest whole number: 74.75 and 5
Write the word sentence as an inequality. One plus a number y is no more than −13. An inequality that represents this word sentence is
Please Help ASAP See Attached photo
Parents wish to have $160,000 available for a​ child's education. If the child is now 7 years​ old, how much money must be set aside at 6 % compounded semiannu
what is 0.3 as in the 3 repeating (i forgot what its called) as a simplified fraction?
Describe the function of the filamentous structures pictured below. Spore production Food absorption Sexual reproduction Asexual Reproduction