不出现0的意思是不是留空？也就是遇0留空？=IF(--LEFT(RIGHT(" "&ROUNDUP($A1,2)*100,15-COLUMN()))) =0,"",LEFT(RIGHT(" "&ROUNDUP($A1,2)*100,15-COLUMN())))
=IF($A1="","",LEFT(RIGHT(" "&ROUNDUP($A1,2)*100,15-COLUMN())))
