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? On Tue, Aug 30, 2011 at 7:41 AM, Martin du Saire <[email protected]> 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 -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
