HURRY NEED HELP!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

=IF(D3<0,REPT("n",-ROUND(D3*100,0)),"")
 
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)
 
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.
 
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".
 
You must log in or register to reply here.
Back
Top