Using 'rept' inside 'If'Solved/Closed

Question

Hello, 


i want to do a rating..example..
Artist                    Rating(numerical)                    Rating(graphical)
akon                           2                                     * * 
lady gaga                    3                                     * * *
rihana                          5                                    invalid rating

i want to automatically fill graphical rating with stars & ranking above 5 must be entered as "invalid rating"..pls help

Mazzaropi · Answer

dinu, Good morning. 

Suppose:
A1 = Artist = Akon
B1 = Rating = 2
C1 = Graphical Rating = Formula

Try to use:

C1 -->
=IF(A1>=5,"Invalid Rating",REPT("*",A1))

Is that what you're looking for.
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Using 'rept' inside 'If'

1 response

Subscribe To Our Newsletter!