What is the syntax for the IF formula in Excel?

[Guest]

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

 

[Guest]

Enter this in D1:

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Richard Buttrey]

Edit Copy
Edit PasteSpecial Values

or

F2 F9 Enter

HTH

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

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________