IF then DO NOTHING

[FoFJeremy]

Hello

Does anybody know a way to create an IF fuction that basically says that if the logical test is false, leave the value that was in the cell alone?

I have a sheet that runs a number of calucations and I want to be able to output the results to one of 3 areas chosen by a in cell dropdown. Right now when I change the selection in the dropdown it turns the output from the previous set of caclulations to false.

I hope that this is clear and thanks for the help

 

[MNpoker]

Not sure I'm following.

Is the old formula the same?

Could you show the IF statement and explain what is changing (or not)

 

[Zack Barresse]

Hmm, maybe ..

=IF(test_condition,if_true,cell)

.. unless of course you are talking about trying to put a formula into a cell and return the same cell's previous value upon FALSE determination. That would create a circular reference which isn't what you want.

 

[FoFJeremy]

That is exactly the case; I'm trying to return the previous value as the False case, obviously without creating some type of circular reference.

any way to accomplish this?

 

[Zack Barresse]

Hi Jeremy,

I apologize for not seeing this sooner. Let's keep all related info away from pm's and on the board for everybody's benefit.

I would recommend you not use Circular Reference for this case. Excel has thousands and thousands of cells, plenty for us to use. Generally and usually, I'm of the opinion that Data should be entered seperately from anything formulated, i.e. reports, queries, etc.

 

[lenze]

Use code, something like

Public PreVal As Variant
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
PreVal = Target.Value
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value > PreVal Then
Exit Sub
Else
Target.Value = PreVal
End If
End Sub

This goes in the WorkSheet module

lenze