Random exponential in excel.

[salimnore]

Hi Excel Forum,

Thank you for taking the time to read this post, was just wondering is there a quick way to generate a number to an exponential power. I ve seen people using subscript function for a power, but can't seem to figure how to generate this randomly.

e.g
2^4 5^3 etc

i need the first number between 2 and 10
and the exponential power between 2 and 5.

Any help will be greatly appreciated.

Thank you

[Pete_UK]

You can use this in a cell somewhere:

=RANDBETWEEN(2,10)^RANDBETWEEN(2,5)

To get another random selection, just press the F9 key.

Hope this helps.

Pete

[salimnore]

You can use this in a cell somewhere:

=RANDBETWEEN(2,10)^RANDBETWEEN(2,5)

To get another random selection, just press the F9 key.

Hope this helps.

Pete

Thank you Pete_UK

This give me a value which works it out for me, i realised after playing with excel i could use 2 seperate cells and put those formulas then have it shown in as Excel as 2 to power of 5 ..thanks for the help

[Pete_UK]

You're welcome.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete