Random Number? Formula?

spg2112 · Mar 20th, 2002, 09:49 AM

Hello All,

I have a grid, rows are profit per unit, starting a 500 and going down to 3,175 in increments of 25. The columns are units starting at 25 and going to 250, incrementing by 5.

I want a formula to calculate a number that is always greater than the cell to the left of it, and always greater than the cell above. Can't go over 40 though. Each column will start slightly above 0 and max at forty.

Any ideas?

Al Chara · Mar 20th, 2002, 10:42 AM

Are the numbers you gave (ie 500 to 3175 and 25 to 250) just column and row headings? How high above 0 do you want the numbers to start at?

spg2112 · Mar 20th, 2002, 10:47 AM

Yes, the columns actually start at 1, then 5 10 15 20 etc...to 250. The Rows start at 500 and go to 3175.

I want to start around .5 and max at 40. I've been playing with RAND()*(C6-D5)+D5, but that's not working. Any help would be greatly appreciated.

Steve

Al Chara · Mar 20th, 2002, 04:37 PM

Don't have time to figure this out, but I will send it to the top of the list. For clarification, do you want the number to be greater than the cell above and less than the cell to the left? Your description in your post did not make sense.

Can I ask what the significance of the row and column headings is and why you want random numbers from .5 to 40?

[ This Message was edited by: Al Chara on 2002-03-20 15:44 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 09:49 AM	#1
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	Hello All, I have a grid, rows are profit per unit, starting a 500 and going down to 3,175 in increments of 25. The columns are units starting at 25 and going to 250, incrementing by 5. I want a formula to calculate a number that is always greater than the cell to the left of it, and always greater than the cell above. Can't go over 40 though. Each column will start slightly above 0 and max at forty. Any ideas?

Mar 20th, 2002, 10:42 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Are the numbers you gave (ie 500 to 3175 and 25 to 250) just column and row headings? How high above 0 do you want the numbers to start at?

Mar 20th, 2002, 10:47 AM	#3
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	Yes, the columns actually start at 1, then 5 10 15 20 etc...to 250. The Rows start at 500 and go to 3175. I want to start around .5 and max at 40. I've been playing with RAND()*(C6-D5)+D5, but that's not working. Any help would be greatly appreciated. Steve

Mar 20th, 2002, 04:37 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Don't have time to figure this out, but I will send it to the top of the list. For clarification, do you want the number to be greater than the cell above and less than the cell to the left? Your description in your post did not make sense. Can I ask what the significance of the row and column headings is and why you want random numbers from .5 to 40? [ This Message was edited by: Al Chara on 2002-03-20 15:44 ]