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 is 12% if 32.?? I forgot how to do this
Why was the 18th amendment proposed
Select the three "belts" of agriculture in the Midwest. Corn belt Hay and dairy belt Rice belt Tobacco belt Wheat belt
PLZ HELP ME!!! LAST QUESTION!!Which revision uses a relative clause to combine the sentences? M.C. Escher was an artist. His works were inspired by mathematics.
Solve for R: I=V/R Begging lol!
What is the slide you are editing called? A. Normal B. Outline C. Slide Sorter D. Current Slide
Escribe una palabra del vocabulario para llenar el espacio. ¿Qué hay en la cocina para limpiar los platos? a0
How many 45 degree angles does it take to make a full turn?
Diane and mick are saving their money to build a tree house. Duane adds $5 to their piggy bank every other week. Mock adds $2 every week. So far they have saved
From our earliest history up until just before the american revolution, abnormal behavior was thought to be caused by