Re: I'm having trouble creating a formula, can anyone help?

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 <[email protected]> wrote:

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


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