314,853 views
30 votes
30 votes
Which is the output of the formula =IF(c4>100;"TRUE";"FALSE"), if the value in c4 is 111

User Jannine
by
3.0k points

1 Answer

5 votes
5 votes

Answer:

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..

Step-by-step explanation:

User Svelandiag
by
2.8k points