| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an IF / AND statement
Is there a way to create an if statment that involves two different cells;
ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
Try this:
=IF(AND(B2=3,C2=1),"YES","Not Yet") HTH, Paul "Pat" .(donotspam) wrote in message ... Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
Try =IF(AND(B2=3,C2=1),"YES","NOT YET")
Hope this helps, Hutch "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
It's the structure of the AND part that's causing the problem:
=IF(AND( B2=3, C2=1),"YES","Not Yet") Cheers, Pete. "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
Thank you TOM & PETE!! It worked perfect. Have an awesome day. ;) -- Thanks, Pat "Pete McCosh" wrote: It's the structure of the AND part that's causing the problem: =IF(AND( B2=3, C2=1),"YES","Not Yet") Cheers, Pete. "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
What am I? Chopped Liver?!!!
You're welcome anyway. "Pat" .(donotspam) wrote in message ... Thank you TOM & PETE!! It worked perfect. Have an awesome day. ;) -- Thanks, Pat "Pete McCosh" wrote: It's the structure of the AND part that's causing the problem: =IF(AND( B2=3, C2=1),"YES","Not Yet") Cheers, Pete. "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
Sorry PCLive . . . I don't see your answer . . . but yes Thank you! ;o
-- Thanks, Pat "PCLIVE" wrote: What am I? Chopped Liver?!!! You're welcome anyway. "Pat" .(donotspam) wrote in message ... Thank you TOM & PETE!! It worked perfect. Have an awesome day. ;) -- Thanks, Pat "Pete McCosh" wrote: It's the structure of the AND part that's causing the problem: =IF(AND( B2=3, C2=1),"YES","Not Yet") Cheers, Pete. "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating an IF / AND statement
That's ok. I was just kidding anyway. My response was the first one.
Maybe it was too quick. Anyway, it was the same as the others and you got the correct answer...that's what's important. Good luck on your project. Regards, Paul "Pat" .(donotspam) wrote in message ... Sorry PCLive . . . I don't see your answer . . . but yes Thank you! ;o -- Thanks, Pat "PCLIVE" wrote: What am I? Chopped Liver?!!! You're welcome anyway. "Pat" .(donotspam) wrote in message ... Thank you TOM & PETE!! It worked perfect. Have an awesome day. ;) -- Thanks, Pat "Pete McCosh" wrote: It's the structure of the AND part that's causing the problem: =IF(AND( B2=3, C2=1),"YES","Not Yet") Cheers, Pete. "Pat" wrote: Is there a way to create an if statment that involves two different cells; ie "IF B2=3, AND C2=1, YES, NOT YET" I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet"))) but it returns a #Value! error. Thank you! -- Thanks, Pat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating ODBC link within SELECT statement | Excel Worksheet Functions | |||
| Creating ODBC link within SELECT statement | Links and Linking in Excel | |||
| Creating ODBC link within SELECT statement | Charts and Charting in Excel | |||
| Creating ODBC link within SELECT statement | Charts and Charting in Excel | |||
| If statement to avoid Creating Circular Reference | Excel Worksheet Functions | |||
![Pat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
