Using 'rept' inside 'If' [Solved/Closed]

Report
-
 dinu -
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

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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
exactly that..thank you very much