my bad. I thought you meant that you wanted a result of zero for any integer 0 through 99...
On Mon, Aug 29, 2011 at 2:50 PM, Paul <paul.m...@gmail.com> wrote: > On Sun, Aug 28, 2011 at 11:20 PM, Randy Barrett < > iatepaintch...@comcast.net> wrote: > I'm trying to make a formula where lets say cell A1 has a number without a > formula. In cell H1 I want to make a formula that follows these guidlines. > A1 H1 > 0-99 0 > 100-199 1 > 200-299 2 > 300-399 3 > 400-499 4 > 500-599 5 > 600-699 6 > 700-799 7 > 800-899 8 > 900-999 9 > 1000+ Platinum > > is it possible and how do i do it? > > On Tue, Aug 30, 2011 at 7:41 AM, Martin du Saire <mdusa...@umn.edu> wrote: > >> int(a1/100) >> >> > When I tried the above suggestion I got all zero's.... I think it was > because with the '-' in the "A" column it wasn't interpreted as a number. > > My suggestion would be to try: > =MID(A1;1;1) > > This will take the first character of the cell. You'll have to add the > 'platinum' row manually, or create an 'if' statement that will take care of > that special case. > > HTH, > /paul > > > -- Martin du Saire Biological Sciences Technician USDA-ARS 470 Borlaug Hall 1991 Upper Buford Circle St. Paul, Minnesota 55108 612-625-9747 mdusa...@umn.edu -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help