View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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)),"")