View Single Post
  #3   Report Post  
RCW
 
Posts: n/a
Default

As indicated in the above response, it repeats a particular character.
However, it would only look like a bar graph of s and n in a plain text font.
Sometimes people format those cells with 'Webdings' etc. so that you
actually see a bar graph of smiley faces or stop signs or houses or any
symbol that's available on your computer.

"N Harkawat" wrote:

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