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 users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
