Suppose cells A5 and B5 contain the values 30000 and 100, respectively. In cell C5, if we apply the formula = IF (A5 <>20000, B5* 20%), what will be the result in C5?

Suppose cells A5 and B5 contain the values 30000 and 100, respectively. In cell C5, if we apply the formula = IF (A5 <>20000, B5* 20%), what will be the result in C5?

A 20

B 10

C 3000

D None of the above

Solution

Correct Answer: Option B