Dear All,
I am randomly generating a set of numbers (in A Column), ranging from 1 to 0 (Where 1=True, and 0=False). I want Columns B and C to draw reference to A such that their random numbers will not conflict with the model based on A.
Thus, I want a formula that looks like this:
IF(A1=1, then B1=0, C=2) BUT IF(B1=1, then A1=0 and C1 = 0) OR/BUT IF(C1=1, then A1=0, B1=0)

Note that A, B and C will randomly generate numbers based on the numbers in A, B or C.
Thank you.