Seeded Pseudo Random Number in Excel using Lambda function

This is a simple example of using the Lambda and Let function for making a Wichmann-Hill seeded Pseudo Random Number Generator in Excel. You should be able to open the name manager select new and give the function a name and copy the following for the reference: =LAMBDA(seed_1,[seed_2],[seed_3], LET(sd_1,MOD(seed_1,200)*30000/200, sd_2,IF(ISOMITTED(seed_2),MOD(ROW(),200)*30000/200,MOD(seed_2,200)*30000/200), sd_3,IF(ISOMITTED(seed_3),MOD(COLUMN(),200)*30000/200,MOD(seed_3,200)*30000/200), MOD(MOD(171*sd_1,30269)/30269+MOD(172*sd_2,30307)/30307+MOD(170*sd_3,30323)/30323,1) ))