Generating sample data within a range


I'm generating sample data in Excel, and I need to create random values within a percentage range.

For example, let's say I have a widget with an average cost of $10.  With any given row, I want to generate values that are plus or minus 20% of $10.  So, the value needs to be anywhere from $8 to $12.  I don't want any values that are less than $8 or more than $12.

Does anyone know a formula or function that can accomplish that?

LVL 13
Who is Participating?
Ejgil HedegaardCommented:
Use =RANDBETWEEN(8,12) to get integer values from 8 to 12, or =RAND()*4+8 to get decimal values.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.