if conditions, and statements
 

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

if conditions, and statements
 

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
---------------
Jacob Skaria


"Cinnabonns" wrote:

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