lundi 9 septembre 2019

Get random value in the range of plus/minus 10% of a cell value in Excel

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