#1 06 Oct 2005 02:50

venom8
Member
Registered: 06 Oct 2005
Posts: 1

Excel Lottery prg

I have a copy of the lottery xcel sheet and was wondering why it stops at around $37,567?

tia

Offline

#2 06 Oct 2005 20:21

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 1,011
Website

Re: Excel Lottery prg

Of course integer variables are limited to 32767 - using LONG you can gamble up to $2,147,483,647, also there was a bug in the 'bonus' calculation

fixed version here:
http://ss64.com/office/lottery.xls

Offline

Board footer

Powered by FluxBB