Need help with simple IF/THEN formula

[Curious Dude]

Hi everyone. I want to set up a formula such that if the contents of cell A1 equals the number 650, that number is automatically copied (or, alternately, the other cell becomes equal) to cell H1.

Can anyone give me a hand?

[mcmahobt]

Assuming I understood your question correctly, in whichever cell you want the rule to apply, try this:

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Curious Dude]

The first formula produced a circular reference error. The second one worked. Thank you for helping me.

There are 2 other small things I'd like to set up if possible. I noticed when I enter the formula and hit enter that the cell then presents a 0 which sits there until the condition (cell A1=650) is satisfied. Is there a way to keep the cell blank unless the condition is satisfied?

Also, if cell A1 is deleted (the number 650 is removed), the 650 remains in cell H1. I want H1 to become blank again if A1 becomes blank. Is this hard to set up?

[Ace_XL]

Try

=IF(A1=650,A1,"")

[Curious Dude]

That works perfectly. Thank you very much!