ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   rolling 4 digit numbers for 4d? (https://www.excelbanter.com/excel-discussion-misc-queries/215733-rolling-4-digit-numbers-4d.html)

Curious

rolling 4 digit numbers for 4d?
 


Shane Devenshire

rolling 4 digit numbers for 4d?
 
Hi,

1. Please put your questions in the body of the email, when we press Replay
in the Web interface we get

"An error occurred while sending your post
--------------------------------------------------------------------------------

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

2. what is your question?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Curious" wrote in message
...


Pete_UK

rolling 4 digit numbers for 4d?
 
I think this is what you want:

=INT(6*RAND()+1)*1000+INT(6*RAND()+1)*100+INT(6*RA ND()+1)*10+INT(6*RAND
()+1)

In future, use the message body to explain what you want, rather than
try to cram it into the header.

Hope this helps.

Pete

On Jan 8, 6:43*am, Curious wrote:




All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com