Check cell value - Results in another cell

[Donrm1]

Version 2010
cell A1 has an "x"
Cell A2 checks A1 for "x"
if true place "x" in cell A3
I have tried this: if(A1="x", A3="x") This does not work

I can get the formula to work if I am in cell A3 with: if(A1="x","x")

However, I need to be able to have user put other data in A3 if "x" is not true and that would cause formulas to be overwritten anytime the value is false and they need to enter in other data. (if the value is true no other data will be entered)

So in other words: I need A to check B and report to C

(Tippung Hat) T.I.A.
Don M.

[Sisyphus]

Hi,
There are no Excel formulas that can write in cells that they don't occupy themselves.
Therefore, you can't have A2 write in A3.
How about using Data Validation to check the value the user puts into A3? You can program the validation to refer to A1 and permit an entry in A3 in dependence of what is in A1.
Would that help?
Happy New Year!

[Don]

Sisyphus is correct and the only way to achieve what you want is to use a macro.

You could use a macro like this:

Code: Select all

Sub test()
If Range("A1").Value = "x" Then Range("A3").Value = "x"
End Sub


Then, just set some event to trigger the macro to run. For instance, you could set this to run when anything is changed in the worksheet by putting it in ThisWorkbook in this sub:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub


and that would make sure the value x was input into cell A3 any time an x was input into cell A1.

hope this helps!