Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    OVERLFOW (Excel 2003)

    Hi all,

    I'm trying to figure some code and need some help.

    On a form I have six checkboxs and a number of values that I can't figure out cause it is not working the way I would like to it to work

    my problem is the variables -

    I have 5 variables.

    The first being 1 to 6 it's an integer.
    The second is based on an option button that if pressed is a multiplying factor of the integer 1 -6...so it's still an integer 1 or 2. max 12.
    The third is an unknown, could be 1 to 2.5 million. - not sure what variable to use on this value
    The fourth is a value of 72000- not sure what variable to use.
    The fifth variable is the answer - again not sure what value to use...


    Thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OVERLFOW (Excel 2003)

    Please don't use ALL CAPS in the subject.

    You haven't explained what you want to do with the values. For many purposes, variables of type Long suffice - they range from -2,147,483,648 to +2,147,483,647. But if you want to multiply all the values together, you'll end up outside the range for Long integers.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: OVERLFOW (Excel 2003)

    Sorry for the Caps,

    So does that mean that all the value are to be variant values?

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OVERLFOW (Excel 2003)

    No. You still haven't explained what you want to do.

  5. #5
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: OVERLFOW (Excel 2003)

    Sorry,

    I would like to divide and multiply these numbers, and I am not sure what variables to use so that I do not get an Overflow error.

    2.5 million/30000.* 6

    Thanks Darryl

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OVERLFOW (Excel 2003)

    Try declaring the variables as Double.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •