If statments, PLEASE HELP

[imported_unknown]

Is it possible for me to set an IF statement to do nothing if a criteria is not met. For example:

my IF statement in the D column is

IF(A:A = "dog", "bark")

I want to be able to do this without affecting the D column for records that do not currently have "dog" in the A column, right now, what happens is if the records don't have "dog" in the A column FALSE is entered in the D column.

 

[Albert 1]

=IF(A:A ="dog","bark","")

 

[imported_unknown]

That simply clears the cell, I want it to do literally nothing. If something is in that cell, I want it to remain there.

 

[Aladin Akyurek]

On 2002-10-04 16:47, xcelarator wrote:
That simply clears the cell, I want it to do literally nothing. If something is in that cell, I want it to remain there.

Entering a formula in a cell, say, D10, wipes out the previous value in D10.

Why

IF(A:A = "dog", "bark")

instead of

IF(A1 = "dog", "bark") ?

 

[Juan Pablo González]

Maybe use a circular reference instead ?

In D10 use

=IF(A1="dog","bark",D10)

 

[lenze]

You will need to use code. Something like:

Sub Fixit()
Dim cel As Range
Dim myVar As Range
Set myVar = Selection
For Each cel In myVar
If cel.Value = "dog" Then cel.Offset(0, 1).Value = "bark"
Next

End Sub

Select the cells in column A and run the macro

 

[imported_unknown]

Thank you for your help. How do I make sure in the macro that it will input the value "bark" into the c or d column, which ever i decide to use?

 

[lenze]

The second argument of the Offset Function indicates how many columns to move over to insert the data. So for column C, change the 1 to a 2, For column D, Change it to 3, etc.

 

[imported_unknown]

That macro will not run due to a syntax error.

 

[lenze]

The macro I gave you was copied from my VBE. It ran fine. Double check everything or paste the code you used.