Welcome Guest
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

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

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)

New Member

Singapore
Member #9171
November 29, 2004
1 Posts
Offline
 Posted: October 20, 2006, 12:09 am - IP Logged
Hi! Floridian,
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
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

 Page 1 of 1