Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:44 am
All times shown are
Eastern Time (GMT-5:00)

A Spreadsheet Question

Topic closed. 3 replies. Last post 10 years ago by winsumloosesum.

Page 1 of 1
PrintE-mailLink
floridian's avatar - DiscoBallGlowing

United States
Member #45802
August 28, 2006
335 Posts
Offline
Posted: October 19, 2006, 1:09 pm - IP Logged

Would anyone be willing to suggest how to structure a formula for the following issue?

If I want to subtract 1 from 0, I can't do it successfully. I am not talking about lottery math, just straight math.  The reason is if I index the formula with the choose argument it will not do the math because it does not recognize anything less than 1. 

The other question is, has anyone been successful at using a spreadsheet formula to perform lottery math?

I am also not sure if I am posting this under the correct forum.  If I am not I apologize in advance. 

 

 

Floridian

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49627 Posts
    Online
    Posted: October 19, 2006, 1:24 pm - IP Logged

    Lottery Math:

    =mod(a2+a3,10) or =mod(a2-a3,10)

      Michael168's avatar - praying hands.jpg
      New Member

      Singapore
      Member #9171
      November 29, 2004
      1 Posts
      Offline
      Posted: October 20, 2006, 12:09 am - IP Logged
      Hi! Floridian,
      Hopefully this will help you out.
      Use =ABS(0-1) give you positive value of 1 instead of -1. Take a look at the help for ABS function.
      Then you will understand what ABS means.
      Regards,
      Michael
        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Online
        Posted: October 20, 2006, 9:00 am - IP Logged

        Would anyone be willing to suggest how to structure a formula for the following issue?

        If I want to subtract 1 from 0, I can't do it successfully. I am not talking about lottery math, just straight math.  The reason is if I index the formula with the choose argument it will not do the math because it does not recognize anything less than 1. 

        The other question is, has anyone been successful at using a spreadsheet formula to perform lottery math?

        I am also not sure if I am posting this under the correct forum.  If I am not I apologize in advance. 

         

         

        Floridian

        Floridian,

        When you subtract 1 from 0 what number are you looking for?

        -1 or 9