Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Statement
Hi All, I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires multiple conditions rather than just one... kind of like this. =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") I know that *AND* won't work, but there has to be a way to do this. To sum up, I want to create an =IF that requires that 3 conditions are met, will provide a certain value if all of them are met and another if any of the 3 are not. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=516887 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Statement
=IF(AND(C5=5; F5=5;G5=1),"Positive","Negative")
HTH -- AP "guilbj2" a écrit dans le message de ... Hi All, I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires multiple conditions rather than just one... kind of like this. =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") I know that *AND* won't work, but there has to be a way to do this. To sum up, I want to create an =IF that requires that 3 conditions are met, will provide a certain value if all of them are met and another if any of the 3 are not. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=516887 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Statement
=IF(AND(C5=5,F5=5,G5=5),"Positive","Negative")
-- Kind regards, Niek Otten "guilbj2" wrote in message ... Hi All, I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires multiple conditions rather than just one... kind of like this. =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") I know that *AND* won't work, but there has to be a way to do this. To sum up, I want to create an =IF that requires that 3 conditions are met, will provide a certain value if all of them are met and another if any of the 3 are not. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=516887 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Statement
Hello guilbj2
You need a nested AND and IF statement: =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") =IF(AND(C55,F5=5,G5=1),"Positive","Negative") The AND statement means that all criteria must be met. Hope this helps Judith "guilbj2" wrote: Hi All, I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires multiple conditions rather than just one... kind of like this. =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") I know that *AND* won't work, but there has to be a way to do this. To sum up, I want to create an =IF that requires that 3 conditions are met, will provide a certain value if all of them are met and another if any of the 3 are not. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=516887 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Statement
=IF(AND(C5=5,F5=5,G5=1),"Positive","Negative")
or =IF((C5=5)*(F5=5)*(G5=1),"Positive","Negative") "guilbj2" wrote: Hi All, I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires multiple conditions rather than just one... kind of like this. =IF(C5=5 *AND* F5=5 *AND* G5=1,"Positive","Negative") I know that *AND* won't work, but there has to be a way to do this. To sum up, I want to create an =IF that requires that 3 conditions are met, will provide a certain value if all of them are met and another if any of the 3 are not. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=516887 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested SumIf statement | Excel Worksheet Functions | |||
Problem with nested IF_OR statement | Excel Worksheet Functions | |||
Nested If statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) |