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

What information can a scientist learn directly from a single fossil? A. How many offspring the organism produced B. How the organism is related to others ООО C
Please help me this is due in like five minutes
when was our motherland Earth established​
If < A and < B are complementary, and < A = 3x + 4 degrees, while < B = 6x - 4 degrees, find x. Select one: a. 10 b. 4 c. 9 d. 21
Sam rolls a fair dice and flips a fair coin. What is the probability of obtaining an odd number and a head?
PLEASEEEE HELPP MEEEE I NEED HELPPPPPPP PLELASEEEEEE I REALLY DONT GET THIS AT ALL I JUST WANNA PAST THE 6th grade
what is the slope of the line shown below (6, 6) (1, -4)
¿Por qué eligieron a Miguel para escribir en el anuario? ¿Qué opción contesta la pregunta correctamente? Había escrito un ensayo maravilloso. Hay sabido de su t
ignore ignore ignore hi hi hi
Which example would be a more complex theme and why