ä½ å¯ä»¥è¯è¯å¨excelä¸å¤çã
ä¸,æç»çæä¿ç1ä½å°æ°,å³éè¿ç¬¬2ä½å°æ°çå¥å¶æ¥è¿è~
=IF(MOD(RIGHT(TRUNC(RC[-1],2),1),2)=1,ROUNDUP(RC[-1],1),ROUNDDOWN(RC[-1],1))
å¨æ°å¼çå³è¾¹è¾å
¥è¿ä¸ªå·¥å¼!
ä¼æ ¹æ®ç¬¬äºä½å°æ°çå¥è¿å¶èæ¥çæ1ä½å°æ°!åæ¶è¿ä¸ªæ ¼è®¾ç½®æ ¼å¼ä¸º1ä½å°æ°(ä¸ç¶æ¯æ´æ°çæ¶å,ä¸ä¼åºç°å°æ°ä½)
äº,æç»çææ´æ°,éè¿å·²ç»è®¾ç½®è¿ä¿ç1ä½å°æ°çå¥å¶æ¥è¿è~
=IF(MOD(RIGHT(ROUND(RC[-1],1),1),2)=1,ROUNDUP(RC[-1],0),ROUNDDOWN(RC[-1],0))å ä¸ºæ ¼å¼ä¸çä¿ç1ä½å°æ°æ¯åèäºå
¥, ç´æ¥ç¨RIGHTå»åæåä¸ä½çè¯,ä¸æ¯åççå°çæåä¸ä½,èæ¯æ²¡æåèäºå
¥çæåä¸ä½,æ以å¨å
¬å¼éå¯åèäºå
¥ä¸æ¬¡!
ç¨å°çå½æ°:
MOD:å两个æ°ç
ä½æ°,éè¿å¤ææåä¸ä½ä¸2çä½æ°,æ¥ç¡®å®æ¯å¥æ¯å¶
TRUNC:èå°æå®ä½æ°(æå®ä½æ°å¯ç©º,å³é¶)
RIGHT:åææ¬(æ°å¼)æå³è¾¹ä¸ä½
ROUND:åèäºå
¥æå®ä½æ°
ROUNDUP:åä¸åæå®ä½æ°
ROUNDDOWN:åä¸åæå®ä½æ°
å¦æä½ æ³æå¦12.34567,æ¯ä½é½æå¥è¿å¶èçæ¹å¼åä¸åæ´,æåå°ä¿çä¸ä½å°æ°,æç¹å¤æ,èªå·±æä¸é¢çæ¹æ¹å§!
ä¸è¬ä¸ä¼å
çæ12.3457,åçæ12.346,åçæ12.34,åçæ12.3?