What is the syntax for the IF formula in Excel?

C

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
 
B

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

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
 
C

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
 
R

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
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top