Question

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

Answer 1

c. 10

Step-by-step explanation:

Given

`D3 = 30`

`D4 = 20`

Required

The result of:
`=IF(D4 < D3,D3-D4,`

First, the condition D4 < D3 is tested.

`D4 < D3 = 20 < 30`

Since 20 < 30, then:

`D4 < D3 = True`

The condition is true, so:

D3 - D4 will be executed.

`D3 - D4 = 30 - 20`

`D3 - D4 = 10`

Hence, the result of the function is 10