Home |
Search |
Today's Posts |
#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)),"") |