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?

Maybe

=IF(A1=1,"Thats True","")

Mike

"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?

Hi,
Post an example of what you want to achieve.
What do you want to happen if the condition isn't met?
Dave.

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?

Excel doesn't work like this.

You can get an empty string ("") that makes the cell look empty--and that's the
closest you can get.

Jennifer B wrote:

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?

--

Dave Peterson

Further to Dave's reply..............

Formulas cannot "copy" from one cell to another.

They can only return data to the cell in which it is written

In your case it would be written in B2 as so

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

which is back to If, then, else

Without the else...............=IF(A2=A1,B1) which would return FALSE if A2<A1


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 13:45:00 -0700, Jennifer B <Jennifer
wrote:

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?

Hi,
"if not, leave cell b2 alone."
If this means leave cell B2 blank, try this in B2:
=IF(A2=A1,B1,"")
Regards - Dave.

"Jennifer B" wrote:

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?

That's what I suspected. Seemed like a circular problem. Oh well, thanks.

"Dave" wrote:

Hi,
"if not, leave cell b2 alone."
If this means leave cell B2 blank, try this in B2:
=IF(A2=A1,B1,"")
Regards - Dave.

"Jennifer B" wrote:

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?

Yes, you can use the IF statement without an else clause. In this case, if the condition is true, the formula will return the result you specify, and if the condition is false, the formula will return nothing.

Here's an example of how to use the IF statement without an else clause:

1. =IF(A110,"Yes","")

In this example, if the value in cell A1 is greater than 10, the formula will return "Yes". If the value in cell A1 is less than or equal to 10, the formula will return nothing.

To implement this in your own spreadsheet, simply replace "A110" with your own condition, and replace "Yes" with the result you want to return if the condition is true. If you don't want to return anything if the condition is false, just leave the second argument of the IF statement blank, like this: "".