| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a Value if 3 Conditions are True
I have a large worksheet of text data. I need a formula or function to return the value in Column D if three (3) conditions are true in Columns A, B & C. e.g. If A1="Name" and B1="Grade" and C1="HOR" then DesMoines A B C D 1 Name Grade HOR DesMoines Thanks for the advice in advance. Brownie -- brownie224 ------------------------------------------------------------------------ brownie224's Profile: http://www.excelforum.com/member.php...o&userid=19679 View this thread: http://www.excelforum.com/showthread...hreadid=541290 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a Value if 3 Conditions are True
I'm not sure what you are looking for if one of those is NOT Name Grade
or HOR but this will work for you... =IF(A1="name",IF(B1="grade",IF(C1="HOR","DesMoines "))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a Value if 3 Conditions are True
In D1, =IF(AND(A1="Name",B1="Grade",C1="HOR),"Des Moines","")
If all three conditions are met, you will ge Des MMoines in cell D1, otherwise D! will be blank. Modify to meet the conditions you are looking to fulfill. "brownie224" wrote: I have a large worksheet of text data. I need a formula or function to return the value in Column D if three (3) conditions are true in Columns A, B & C. e.g. If A1="Name" and B1="Grade" and C1="HOR" then DesMoines A B C D 1 Name Grade HOR DesMoines Thanks for the advice in advance. Brownie -- brownie224 ------------------------------------------------------------------------ brownie224's Profile: http://www.excelforum.com/member.php...o&userid=19679 View this thread: http://www.excelforum.com/showthread...hreadid=541290 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a Value if 3 Conditions are True
Let me clarify a point. The data in Column D varies. I want it to return whatever is in column D if all conditions in Column A, B & C are true. If the conditions are NOT met then return a blank cell. Thanks -- brownie224 ------------------------------------------------------------------------ brownie224's Profile: http://www.excelforum.com/member.php...o&userid=19679 View this thread: http://www.excelforum.com/showthread...hreadid=541290 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a Value if 3 Conditions are True
I think you should use the both the AND and IF function like this:
=IF(AND(A1="Name";B1="Grade";C1="HOR");"Des Moines";"") Per Erik On Thu, 11 May 2006 16:04:13 -0500, brownie224 wrote: Let me clarify a point. The data in Column D varies. I want it to return whatever is in column D if all conditions in Column A, B & C are true. If the conditions are NOT met then return a blank cell. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a Value if 3 Conditions are True
"Per Erik Midtrød" wrote in message
... On Thu, 11 May 2006 16:04:13 -0500, brownie224 wrote: Let me clarify a point. The data in Column D varies. I want it to return whatever is in column D if all conditions in Column A, B & C are true. If the conditions are NOT met then return a blank cell. I think you should use the both the AND and IF function like this: =IF(AND(A1="Name";B1="Grade";C1="HOR");"Des Moines";"") =IF(AND(A1="Name",B1="Grade",C1="HOR"),D1,"") -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
| Summing values if conditions are true | Excel Worksheet Functions | |||
| 2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
| Count Occurances if two conditions true | Excel Worksheet Functions | |||
| returning a count if two conditions are met | Excel Worksheet Functions | |||
Hybrid Mode
