Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Cells
I have four columns A1=Name B1=Y C1= D1=Y (Y mean yes and blank means no in celss B-D) What i would like to do is for excel to compare cells B, C, and D and return the name in A1 if B1 is blank and there is a Y in C1. Please help...Thanks! -- gdeleos ------------------------------------------------------------------------ gdeleos's Profile: http://www.excelforum.com/member.php...o&userid=32540 View this thread: http://www.excelforum.com/showthread...hreadid=523249 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Cells
Try to use the following formula:
=If(and(B1="",C1="Y"),A1,"") (There is no comparison for cell D1 in your question) -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download ================================= "gdeleos" wrote in message ... I have four columns A1=Name B1=Y C1= D1=Y (Y mean yes and blank means no in celss B-D) What i would like to do is for excel to compare cells B, C, and D and return the name in A1 if B1 is blank and there is a Y in C1. Please help...Thanks! -- gdeleos ------------------------------------------------------------------------ gdeleos's Profile: http://www.excelforum.com/member.php...o&userid=32540 View this thread: http://www.excelforum.com/showthread...hreadid=523249 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Cells
Try...
=IF(B1="",IF(C1="Y",A1,""),"") Hope this helps! In article , gdeleos wrote: I have four columns A1=Name B1=Y C1= D1=Y (Y mean yes and blank means no in celss B-D) What i would like to do is for excel to compare cells B, C, and D and return the name in A1 if B1 is blank and there is a Y in C1. Please help...Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |