Excel Formulas

[CharlesErasmus]

Good morning, how do I make a value automatically appear in a nother cell if value is entered into another cell, for excample: I have a value in B2. lets say 253, when I enter another value into B3 (534) I want the value in B2 (253) to automatically appear in A2.

A	B
	253
I want the "253" to automatically apear in this cel as soon as I enter the "534" into B3	534

<TBODY>
</TBODY>

 

[Dryver14]

=IF(B3=534,253,"") in cells B2

 

[CharlesErasmus]

=IF(B3=534,253,"") in cells B2

Thank you, I changed it a bit to =IF(B3>0,B2,""), it's working perfectly.