What is the syntax for the IF formula in Excel?

[Christina]

2Please help with the syntax for the following:

If the contents in A1 = the contents in A2, put the contents of B2 in D1.

Thanks, ck

[David Billigmeier]

Enter this in D1:

=IF(A1=A2,B2,"")


--
Regards,
Dave


"Christina" wrote:

> 2Please help with the syntax for the following:
>
> If the contents in A1 = the contents in A2, put the contents of B2 in D1.
>
> Thanks, ck

[BekkiM]

In D1, put the following formula:

=IF(A1=A2,B2,"")

That last "" takes care of the "else" part of your equation--in other words,
what to do in D1 if A1 does not equal A2.

"Christina" wrote:

> 2Please help with the syntax for the following:
>
> If the contents in A1 = the contents in A2, put the contents of B2 in D1.
>
> Thanks, ck

[Christina]

Thank you so much for your help. That definitely works.

By any chance do you also know how to make the result of the formula a value
so that I can delete the reference. So, below, I want to delete B2 but have
the contents in D1 remain.

Thanks, Christina

"David Billigmeier" wrote:

> Enter this in D1:
>
> =IF(A1=A2,B2,"")
>
>
> --
> Regards,
> Dave
>
>
> "Christina" wrote:
>
> > 2Please help with the syntax for the following:
> >
> > If the contents in A1 = the contents in A2, put the contents of B2 in D1.
> >
> > Thanks, ck

[Christina]

Thank you so much for your help. That definitely works.

By any chance do you also know how to make the result of the formula a value
so that I can delete the reference. So, below, I want to delete B2 but have
the contents in D1 remain.

Thanks, Christina


"BekkiM" wrote:

> In D1, put the following formula:
>
> =IF(A1=A2,B2,"")
>
> That last "" takes care of the "else" part of your equation--in other words,
> what to do in D1 if A1 does not equal A2.
>
> "Christina" wrote:
>
> > 2Please help with the syntax for the following:
> >
> > If the contents in A1 = the contents in A2, put the contents of B2 in D1.
> >
> > Thanks, ck

[Richard Buttrey]

Edit Copy
Edit PasteSpecial Values

or

F2 F9 Enter

HTH


On Mon, 10 Oct 2005 14:34:05 -0700, Christina
<[email protected]> wrote:

>Thank you so much for your help. That definitely works.
>
>By any chance do you also know how to make the result of the formula a value
>so that I can delete the reference. So, below, I want to delete B2 but have
>the contents in D1 remain.
>
>Thanks, Christina
>
>
>"BekkiM" wrote:
>
>> In D1, put the following formula:
>>
>> =IF(A1=A2,B2,"")
>>
>> That last "" takes care of the "else" part of your equation--in other words,
>> what to do in D1 if A1 does not equal A2.
>>
>> "Christina" wrote:
>>
>> > 2Please help with the syntax for the following:
>> >
>> > If the contents in A1 = the contents in A2, put the contents of B2 in D1.
>> >
>> > Thanks, ck

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________