| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if conditions, and statements
I am having trouble creating "and conditions" and "if conditions". can anyone
help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditions in if statements | Excel Discussion (Misc queries) | |||
| Multiple conditions and IF Statements | Excel Discussion (Misc queries) | |||
| IF statements and conditions | Excel Worksheet Functions | |||
| If statements and conditions - again!! new prob | Excel Worksheet Functions | |||
| Sum if statements with conditions | Excel Worksheet Functions | |||
Linear Mode
