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

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")))

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

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
>
>

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
<brownie224.27nvun_1147381807.8316@excelforum-nospam.com> 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

"Per Erik Midtrød" <perimidt@start.no> wrote in message
news:vle7625alvr11c1ugjs04hmicn7pn1m5m7@4ax.com...
> On Thu, 11 May 2006 16:04:13 -0500, brownie224
> <brownie224.27nvun_1147381807.8316@excelforum-nospam.com> 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