Using 'rept' inside 'If'
Solved/Closed1 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