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

Journal: End Cretaceous Mass Extinction Compile a list of the evidence supporting the impact hypothesis as the cause of the Cretaceous mass extinction. Now, do
In the diagram, what is mVSR?
Can i have some pointers on how you write a diary entry?
plz...solve this question....If n(A) = 37, n(B) = 50, and A is subsets of B, find n(AUB).​
why did Rosa say that there was no reason to save them?​
which two statements are both true?
which two statements are both true?
Multiply. Q+5/2x4q/q+4
What was the main idea of the Great Gatsby.. explain ?
Sam delivers 167 newspapers every morning, he receives 5 cents per paper seven day a week, what is his weekly pay