Using 'rept' inside 'If'
Solved/Closed
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
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 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 13, 2015 at 07:35 AM
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
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
Aug 13, 2015 at 08:20 AM