if, then, do nothing?

[merlin777]

IF statements are 'IF X is true, do Y, else do Z'.

Is there a statement that does 'IF X is true, do Y, else do nothing?

I'm basically looking for an IF statement that leaves the existing value unchanged if a condition is not true.

any thoughts?

 

[vds1]

Something like,

If x = True Then
    'DO Y
End If

 

[merlin777]

that's it!

now can i do that with a formula or do i have to dust off my rather limited vba?

 

[VoG]

now can i do that with a formula or do i have to dust off my rather limited vba?

Something like

=IF(A1>30,B2*C3,"")

 

[brian.wethington]

are you talking about doing this in a particular cell and updating that particular cell. If so, then the only way that can be done is with VBA if no, then you can use a function like this:

=If(A1=[condition], [change],A1)

where you would have to set [condition] and [change]

if you want the same cell to be adjusted then

 If Range(A1) = [condition] then Range(A1)=[change]

would do

 

[merlin777]

thanks, brian - i'll give those a try.

vog - thanks for the suggestion but the cell would still be changed to "" if the condition was untrue and i want to keep the existing value.

 

[merlin777]

brian, is the second statement vba? I can't get anything like that to work in a cell.

 

[brian.wethington]

Yes the 2nd statement is VBA. As I mentioned there is no input you can make in a cell that will update a different cell without using VBA.

 

[brian.wethington]

are you talking about doing this in a particular cell and updating that particular cell. If so, then the only way that can be done is with VBA if no, then you can use a function like this:

=If(A1=[condition], [change],A1)

where you would have to set [condition] and [change]

if you want the same cell to be adjusted then

 If Range(A1) = [condition] then Range(A1)=[change]

would do

wow that is terrible, sorry, the 2nd statement should be

 If Range("A1") = [condition] then Range("A1")=[change]