ROUNDUP(A1,A1,0

IF(MOD(ROW(A1)-1,3),ROUNDUP(ROW(A1)/3,0),0)请高手帮我讲解一下此公式, B2单元格先输入=A1*(1-0%)公式后,再在B2单元格设函数ROUNDUP,怎么一次做到? 求excel中=ROUNDUP(A1/1.38,1)如何用函数做到小数点后1位数小于5就取5,大于等于5就进1? countif（a1:b2,a1: COUNTIF(A1:D30,A1: =IF(SUM(A1:A5)>0,SUM(A1:A5) 如果A1>0,B1=C1；如果A1=0,B1=D1；如果A1 excel 公式 如果A1-B1>0,则结果为（A1-B1）*0.2,如果A1-B1 [=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$B:$C,COLUMN(A1),)) excel中,A1如果大于0,则A2=A1,A1 TEXT(A1*B1/C1,"0."&REPT("0",MIN(LEN(A1:C1)-FIND(".",A1:C1))) 已知：a1