excel-day11-1

数学函数

 

 

=ROUND(F2,1)

=ROUNDUP(F2,2)

=ROUNDDOWN(F2,2)

 

 

=IF(MOD(RIGHT(LEFT(B2,17),1),2)=1,"男","女")

 

 

=IF(MOD(C2,1)>=0.5,INT(C2)+0.5,INT(C2))

 

 

=INDEX(E:E,MATCH(H4,A:A,0))

 

 

=INDEX($A:$A,COLUMN()-2)

 

 

 

=INDEX($E:$E,ROW()*5-17)

 

 

=INDEX($A$1:$A$15,ROW()*3+COLUMN()-10)