It repeats the character "s" D3*100 times which means if D3 is 0.05 then
the cell will display "sssss" (5 times (0.05 * 100)
"The_ tone" <The_
wrote in message
...
WHAT DO THESE FORMULAS DO!!??? NEED QUICK!!
=IF(D30,REPT("s",ROUND(D3*100,0)),"")
=IF(D3<0,REPT("n",-ROUND(D3*100,0)),"")