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

2011/8/29 Randy Barrett <[email protected]>:
> 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 the number to be evaluated is in A1 and the result is in H1, then
type the following in H1:
=IF(A1>=1000;"Platinum";INT(A1/100))

Example:
A1=563 ⇨ H1=5
A1=1328 ⇨ H1="Platinum"


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help