Column A - represents Years
Ex: =IF(A2<5,(RANDBETWEEN(30,50)),(RANDBETWEEN(40,60)))
I want that the function “random between” to be applied between “30;50” if the no. of years are less than 5, and if it’s greater than 5, the function to be applied between “40;60”
Sorry for this questions, i’m new to this stuff, and I need it for a project