Using 'rept' inside 'If'

Solved/Closed
dinu - Aug 13, 2015 at 06:10 AM
 dinu - Aug 13, 2015 at 08:20 AM
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

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Aug 13, 2015 at 07:35 AM
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
0
exactly that..thank you very much
0