Question

f) If cell A3 contains 10 and cell A4 contains 15, then what is the return
value of the formula = AND(A3 > 9, A4 < 20)?​

Answer 1

Answer:

The return value of the formula = AND(A$3 > 9$, A$4 < 20$) is TRUE.

Explanation:

Given: Cell A$3$ $=10$ and Cell A$4$ $=15$.

To Find: The return value of the formula = AND(A$3>9$, A$4 < 20$).

Solution: The AND function is used to adds values, cell references or ranges to define up to $255$ conditions in Excel.

So, in this question the given conditions are A$3 > 9$ and A$4 < 20$.

Step 1: Add given value of A$3$ in given condition A$3 > 9$,

$10 > 9$

Result is TRUE.

Step 2: Add given value of A$4$ in given condition A$4 < 20$,

$15 < 20$

Result is TRUE.

The below given image describes the functions values.

Hence, the return value of the formula = AND(A$3 > 9$, A$4 < 20$) is TRUE.