Which is the output of the formula = IF (C4>100; "TRUE"; "FALSE"), if the value in cell C4 is 111?

a) true

b) false

c) 100

d) 111

the output of the would be "TRUE"

Its output is "true" if the formula statement was corrected. But formula statement contain an error.

Explanation:

IF function contain 3 part. 1st part is Logic function, 2nd part is one value if condition is TRUE and 3rd or last part is another value if condition is FALSE. To separate each part comma sign (,) is used.

In given data, the formula is incorrect because semi-colon is used in place of comma

The correct formula statement are: = IF (C4>100, "TRUE", "FALSE")

Then its output will "TRUE"

According to correct formula

It means that if no. in cell C4 is greater than 100 it shows output TRUE otherwise FALSE ...