if conditions, and statements

  • Thread starter Thread starter Cinnabonns
  • Start date Start date
C

Cinnabonns

I am having trouble creating "and conditions" and "if conditions". can anyone
help?
 
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
 
Back
Top