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.