RSS 2.0 Feeds
Latest Forum Topics
Web Site Change Log
RSS info, more feeds
Topic closed. 2 replies. Last post 12 years ago by reddog.
I am trying to add to cells together ie, A1+A2 and have it start back to counting from 1 on up once it reaches 34. Problem I am having is some of the cells will total 0 if the sum of two cells equal 34. Pick 5 does not have a 0. It starts from 1 to 34. What string should I be using?
Here is the string I am currently using;
starting in cell A3
what should I do differently to keep 0 from popping up?
rewrite your code as follows:
In english, test to see if the sum is 0, if yes then let it equal 1, else let it be whatever it will be.
Thank you Sir Metro.
If you haven't already, check out the About Us page that explains the main features of our site.
Also, please take a few moments and review the rules for posting at Lottery Post.
Any time you see a gray-underlined link, you can click the link to see a popup menu of options.
We try to include instructions on each page. Check for help content on the page that's giving you trouble.
The next place to seek help is our dedicated Help forum that contains detailed assistance for frequently requested topics.
If something isn't working properly, our automated Browser Test page can quickly identify common problems.
Finally, the Contact Us page has an incredible wealth of self-help material that answers 95% of the questions we are asked.
We always welcome feedback and suggestions.
About Us • Site Map • Membership Features • Advertising Opportunities • Change Log • Rules • Linking to Lottery Post
Index of Feeds • Lottery News • Event Calendar • Latest Forum Posts • Web Site Change Log
Search the news, forums, blogs, and even your private messages at our Search page.
This page was generated in 0.0361 seconds.Copyright © 1999-2016 Speednet Group. All rights reserved.