I want a formular that gives a star rating when something is between 2 numbers

[nijode999]

So,

I can figure something out, but I don't think it is a hard one.


So I have a B11 with a number between 1-100.


I want a create a formula that convert this number to stars like this:

★★★★★ 96-100

★★★★½ 86-95

★★★★ 76-85

★★★½ 66-75

★★★ 56-65

★★½ 46-55

★★ 36-45

★½ 26-35

★ 16-25

½ 0-15

What is the best way I can do this. So if B11 is 43 I want B13 to show ★★ and when B11 is 76 I want B13 to show ★★★★ stars. Any way to do this?

Already thanks!

 

[nijode999]

That works indeed! Great!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[tusharm]

So,

I can figure something out, but I don't think it is a hard one.


So I have a B11 with a number between 1-100.


I want a create a formula that convert this number to stars like this:

★★★★★ 96-100

★★★★½ 86-95

★★★★ 76-85

★★★½ 66-75

★★★ 56-65

★★½ 46-55

★★ 36-45

★½ 26-35

★ 16-25

½ 0-15

What is the best way I can do this. So if B11 is 43 I want B13 to show ★★ and when B11 is 76 I want B13 to show ★★★★ stars. Any way to do this?

Already thanks!

To make the solution transparent, consider putting the star-mapping into a range such as the below and then using a vlookup

	G	H
7	0	½
8	16	★
9	26	★½
10	36	★★
11	46	★★½
12	56	★★★
13	66	★★★½
14	76	★★★★
15	86	★★★★½
16	96	★★★★★

=VLOOKUP(B11,G7:H16,2,TRUE)