How to use the function - IF(and?

I am trying to creat a spreadsheet that uses the function =IF(AND????

I have five possible outcums. For example if the sun is rising then it is warm, if the sun is settinmg  then it is cold.
cssc1Asked:
Who is Participating?
 
JPConnect With a Mentor IT DirectorCommented:
See the attached file, just change the value in the drop down in cell A1.
5-Condition-If-statement.xlsx
0
 
JPConnect With a Mentor IT DirectorCommented:
The (AND  is going to be used for combining multiple criteria for your if statement, you could probably get by with just an if statement.
0
 
dinodinuConnect With a Mentor Commented:
for eg., if you want to check if a value is between 10 and 15, the if(and will look like:
=IF(AND(B2 < 15, B2 > 10),"TRUE","FALSE")

Assuming B2 contains the value and this formula is typed in another cell
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.