IFS and RANDBETWEEN HELP NEEDED

Question

Purpose: Create a dummy dataset with specific conditions

Data so far:

Column B: Pick a random value between K2 and K3 and store it in this respective cell [Do this for every cell in Column B]

Problem - How to:

Create an IF statement in Column C that does the following:

IF the value for the MATCHING ROW in Column B is K2:Pick a random value between L6 to L8 and store it in this cell

ELSE:
Pick a random value between M6 to M8 and store it in this cell

sergeibaklan · Answer

CrispyBacon95&nbsp;
Your own formula if adjust a bit shall work
=IF(B2=$K$6,
    INDEX($L$6:$L$8,RANDBETWEEN(1,COUNTA($L$6:$L$8)),1),
    INDEX($M$6:$M$8,RANDBETWEEN(1,COUNTA($M$6:$M$8)),1)
)

Forum Discussion

IFS and RANDBETWEEN HELP NEEDED

1 Reply

Resources