I have a column with positive numbers and want to calculate for each of them a random value, which is however placed in the range of 10%, so the calculated value is maximally 10% lower or higher as the original value.
The second requirement is - the result must be higher then zero.
I tried a formula like the following - but it seems to be wrong, because of not matching the second requirement, i get sometimes values lower then zero.
=IF(RAND()<0.5,(B2+(B2/100)*90)-(RANDBETWEEN(B2-0.1,B2+0.1)),(B2-(B2/100)*90)+(RANDBETWEEN(B2-0.1,B2+0.1)))
Aucun commentaire:
Enregistrer un commentaire