The first formula repeats "s" D3 * 100 times to the nearest integer, only if
D3 contains a positive number, otherwise blank. If D3 were 0.5, it would
display 50 "s"s. If D3 were -0.5, it would display nothing.
The second formula repeats "n" Abs(D3)*100 times to the nearest integer if
D3 contains a negative number, otherwise blank. If D3 were 0.5, it would
display nothing. If D3 were -0.5, it would display 50 "n"s. If D3 were
-0.00005, it would display 1 "n".
--
Assigning guilt doesn't solve the problem


"The_ tone" wrote:

WHAT DO THESE FORMULAS DO!!??? NEED QUICK!!

=IF(D30,REPT("s",ROUND(D3*100,0)),"")

=IF(D3<0,REPT("n",-ROUND(D3*100,0)),"")