Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement with AND or OR?
Hi,
I have a range of cells a1:a3. In a1 I will have a number between 0 - 5. In a2 I will have a number between 0 - 5. In a3 I want a function that returns "Fail" if a2 is above 0, and "Dropped" if a1 is above 0 irrelevant to what number is in a2. ie: a number above 0 in a1 will always return "Dropped" no matter what number is a2. If a1 and a2 are both at 0 then "Pass" will be returned. My starting point is =IF(A20,"Fail","Pass"). Please can you help? -- Thank you, Colin. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |