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

Randy Barrett <[email protected]>
Newsgroups gmane.comp.openoffice.questions
Message-ID <[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?
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.