| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Functions
Is there a way to combine the "IF" function and the "AND" function in one
formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Functions
=if(and(a1=5,b1="yes"),"both are true","at least one is not true")
MikeM wrote: Is there a way to combine the "IF" function and the "AND" function in one formula? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Functions
The following conditions is IF A1 = 12 and B10 = 15 and C2 = 0 then condition
is met, otherwise it's not met. =IF(AND(A1=12,B10=15,C22=0),"Condition Met", "Condition Not Met") -- Kevin Backmann "MikeM" wrote: Is there a way to combine the "IF" function and the "AND" function in one formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Functions
I want to return a value from another cell as opposed to a "true" or "false",
is this possible? MikeM "Dave Peterson" wrote: =if(and(a1=5,b1="yes"),"both are true","at least one is not true") MikeM wrote: Is there a way to combine the "IF" function and the "AND" function in one formula? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Functions
Just replace the text values with the cell you want referenced:
=IF(AND(A1=12,B10=15,C22=0),Z10, X11) -- Kevin Backmann "MikeM" wrote: I want to return a value from another cell as opposed to a "true" or "false", is this possible? MikeM "Dave Peterson" wrote: =if(and(a1=5,b1="yes"),"both are true","at least one is not true") MikeM wrote: Is there a way to combine the "IF" function and the "AND" function in one formula? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Functions
Thanks for your help!
"MikeM" wrote: I want to return a value from another cell as opposed to a "true" or "false", is this possible? MikeM "Dave Peterson" wrote: =if(and(a1=5,b1="yes"),"both are true","at least one is not true") MikeM wrote: Is there a way to combine the "IF" function and the "AND" function in one formula? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining IF & AND functions | Excel Discussion (Misc queries) | |||
| Combining functions AND and OR | Excel Worksheet Functions | |||
| Combining IF and OR Functions | Excel Discussion (Misc queries) | |||
| Combining IF OR and AND functions | Excel Worksheet Functions | |||
| Combining functions | Excel Worksheet Functions | |||
Linear Mode
