Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to check rows
I have the following example of rows A B C D(function) Y N 234 N Y Y 234 Y N Y 234 Y N Y 234 Y N Y 234 Y Y N 435 N Y N 435 N Y N 435 N Y N 435 N I would like for D to have a function where it will return either Y or N. It would return Y if B contained Y for the set of numbers... ie 234 or 435 Would someone provide me with some help. I have this if function. Maybe this could be expanded? =IF((AND(J2="N",D2="Y")),"Y","N") -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=556241 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to check rows
Hi!
Try this: =IF(AND(B1="Y",OR(C1={234,435})),"Y","N") Biff "exceluser2" wrote in message ... I have the following example of rows A B C D(function) Y N 234 N Y Y 234 Y N Y 234 Y N Y 234 Y N Y 234 Y Y N 435 N Y N 435 N Y N 435 N Y N 435 N I would like for D to have a function where it will return either Y or N. It would return Y if B contained Y for the set of numbers... ie 234 or 435 Would someone provide me with some help. I have this if function. Maybe this could be expanded? =IF((AND(J2="N",D2="Y")),"Y","N") -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=556241 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GetPivotData function returning N/A error for some rows | Excel Discussion (Misc queries) | |||
numerical integration | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel |