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.
Hi KwabenaTakyi- Excel formulae don't allow circular references, such as "the value of B depends on the value of A which depends on the value of B"
Hi,
Here are three formula's that may meet your criteria.
A1B1
Please Login or Register to view this content.C1Please Login or Register to view this content.CheersPlease Login or Register to view this content.
Hi
Thanks for your help..... the Codes for A1 and B1 run just fine, however C1 conflicts. The point is C1 should return 1 if and only if A1 and B1 are 0 each.
the idea is that on a ROW of 4 (variables) choice of TRUE (1) can only be once and the others must return FALSE(0).
Thank you and hope you provide further insight
Ok, so what if it has only a non looped reference? such as explained in the response to Southward?
I suggest the following: add a fifth cell (say E1 for row 1):
E1: =INT(RAND()*4), which yields {0,1,2,3}
This gives each column an even chance.
A1: =--($E1=0)
B1: =--($E1=1)
C1: =--($E1=2)
D1: =--($E1=3)
OR Better yet:
E1: =INT(RAND()*4)+1, which yields {1,2,3,4}
A1:D1 =--($E1=COLUMN())
Last edited by leelnich; 05-25-2017 at 09:49 AM.
OK. Change
C1 toPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks