if conditions, and statements

C

Cinnabonns

I am having trouble creating "and conditions" and "if conditions". can anyone
help?
 
J

Jacob Skaria

In general

'AND() returns true only if all conditions are satisfied
=IF(AND(condition1,condition2,...), TRUE statement, FALSE statement)

'OR() returns true if any one of the condition is met
=IF(OR(condition1,condition2,...), TRUE statement, FALSE statement)

Example of a condition would be say
IF(AND(A1>=1,A1<=10),"Cell A1 between 1 and 10","Outside the range 1-10")

If this post helps click Yes
 
Top