What is the syntax for the IF formula in Excel?
 

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

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

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

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

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

Edit Copy
Edit PasteSpecial Values

or

F2 F9 Enter

HTH


On Mon, 10 Oct 2005 14:34:05 -0700, Christina
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
__________________________