I have the same question, I think. I want the statement for cell b2 to be (in
words), "If cell a2 equals cell a1, then copy data from cell b1 to b2, if
not, leave cell b2 alone." I do not want it to return "false" or "0" or
anything. I want it to leave what is in that cell alone. Any ideas? Thanks
in advance.

"Simi Singh" wrote:

I have been trying to use the IF statement without else.
I just want If and then...
is there any way I can implement that?