Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HURRY NEED HELP!!
WHAT DO THESE FORMULAS DO!!??? NEED QUICK!!
=IF(D30,REPT("s",ROUND(D3*100,0)),"") =IF(D3<0,REPT("n",-ROUND(D3*100,0)),"") |
#2
|
|||
|
|||
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)),"") |
#3
|
|||
|
|||
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)),"") |
#4
|
|||
|
|||
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)),"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|