Question: How do you create an IF statement in Sheets to check if the value in cell B 5 is greater than 1 0 ? (

How do you create an IF statement in Sheets to check if the value in cell B5 is greater than 10?(Hint: Search the documentation, or try each formula on your own)
Group of answer choices
=if(B5<10,TRUE,FALSE)
=if(B5=10,TRUE,FALSE)
=if(B5>10,TRUE,FALSE)
=if(B5 IS GREATER THAN 10,TRUE,FALSE)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!