int(a1/100) On Sun, Aug 28, 2011 at 11:20 PM, Randy Barrett <[email protected]>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? > -- > ------------------------------**------------------------------**----- > To unsubscribe send email to > users-unsubscribe@openoffice.**org<[email protected]> > For additional commands send email to [email protected] > with Subject: help > -- Martin du Saire Biological Sciences Technician USDA-ARS 470 Borlaug Hall 1991 Upper Buford Circle St. Paul, Minnesota 55108 612-625-9747 [email protected] -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
