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
