Random number based on other cell conditions

Hi everyone,

I'm looking to make a data set for Credit rating, income and then 1 or 0 in column c for approved or declined based on those numbers for Credit Ratings and Income. I want it to be random but I want Credit ratings to be more likely to be higher if income is higher and if Credit rating and income are high I want it to be more likely to have a 1 for approved. The only way I can think of is with a nested if statement (=if(A3=">60000",randbetween(600,1000),randbetween(0,700)); this would be for random Credit rating. Is there a better way of doing this?

I hope that made sense.

Thanks

It's quite ridged, for instance what if I wanted 20000-40000 to have between 200-600, 40000-60000 to have 400-700 and 60000+ to have between 600-1000. Also How do I then do the 0 and 1 column based on the Credit Score Column and the Income column?