Need help with excel formula/macro

W

werner

Expert Member
Joined
Jun 27, 2005
Messages
3,401
Reaction score
11
Hi Guys, excel newb here

Have an interesting problem (for me at least)

I have a list of numbers (prices), lets say A1 to A77000

I want to increase each price individually by a random percentage, but no less than e.g. 12% and no more than e.g. 25%

After this is applied, each price would have increased individually by a certain random percentage, but within the limits set above.

Ideas?
 
Can you clarify please?

what do you want as a final result, do you want random numbers between 12% and 25% of each number which you specified ?
 
random numbers between 12% and 25% added to the first numbers.

A1 is e.g. 10
so after this tweak, a1 becomes somewhere between 11.2 and 12.5
similarly, a2 also changes, but hopefully by a slightly different percentage..and so on.

It doesnt matter to me really if A1 remains the original value and the resultant addition ends up in B1 and so on......e.g. a1=10, b1=12.5

thank you in advance
 
Do you want fractional values in the range?

Can use RANDBETWEEN(min,max) but don't think it will give you a fractional random
 
hmmm, i hope i understand you correctly.

if cell A1=10 and A2 = 15 etc. then paste following formula in cell B1 and copy downwards etc

=RANDBETWEEN(($A1*1.12),($A1*1.25))

this will return a random number of the price in column A in column B
 
thank you guys....I'll run this on my sheet later today...
 
what an odd question, this seriously sounds like someone trying to generate a sample set that will reflect a predetermined position ;)
 
Good day

I wonder if you can help me.

I need to create a formula for my template

Column F contains ratings (R/A/G) and there is different Risk areas (column B). I want to colour column B according to the results in Column F.
For instance, say there is 2 Green and 1 Red, the colour in Column B must change to Amber (orange).
Is something like that possible?

Hope you can assist me.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X