| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statements
I need to embed an if/and statement that has more than two conditions.: i.e.
if h2=h3 and (K3=9,K2=7),"9-8" In other words, I need three conditions to apply to each if statement. Is that possible and how would I do that? -- Motaad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statements
=IF(AND(H2=H3,K3=9,K2=7),"9-8","answer if false")
-- David Biddulph "Motaad" wrote in message ... I need to embed an if/and statement that has more than two conditions.: i.e. if h2=h3 and (K3=9,K2=7),"9-8" In other words, I need three conditions to apply to each if statement. Is that possible and how would I do that? -- Motaad |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statements
=IF(AND(H2=H3,K3=9,K2=7),"9-8","")
"Motaad" wrote: I need to embed an if/and statement that has more than two conditions.: i.e. if h2=h3 and (K3=9,K2=7),"9-8" In other words, I need three conditions to apply to each if statement. Is that possible and how would I do that? -- Motaad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM and IF statements | Excel Worksheet Functions | |||
| MAX, IF statements? | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements, I think?? | Excel Discussion (Misc queries) | |||
| IF/AND Statements | Excel Worksheet Functions | |||
Hybrid Mode
