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

On 8/28/2011 11:20 PM, Randy Barrett 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?
If  I'm correctly understanding your guidelines, enter the following 
into cell H1 and copy it down into cells H2, H3, ...
=IF(A6<1000;QUOTIENT(A6;100);"Platinum")

My bad!  Obviously this should read
=IF(A1<1000;QUOTIENT(A1;100);"Platinum")
which is, of course equivalent to the solution provided by
Johnny Rosenberg


-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help