Excelå½æ°ä¸çä¸çäºç¨ <> 表示ãå°±æ¯å°äºå·å大äºå·ï¼å¨è±æç¶æä¸é®çä¸æä½shift+<+>,å¦ä¸å¾ã
è½¯ä»¶å·¥å ·:excel
1ãæ¯å¦å¤æD7åE7ï¼å¦æD7ä¸çäºE7å°±è¿åçï¼å¦åè¿ååã
2ãè¾å ¥å ¬å¼ï¼=IF(D7<>E7,"ç","å")ï¼ä¸å¾D7åE7é½ä¸º1å°±è¿ååï¼D8åE8ä¸åè¿åçã
å ¶ä»ç¸å ³ç¬¦å·ï¼å¤§äºçäºå·ç¨â>=â表示ï¼å°äºçäºå·ç¨â<=â; ä¹å·ç¨â*â表示ï¼é¤å·ç¨â/â表示ã常è§çè¿ææ°ç»â{}âï¼è¿ä¸ªä¸æ¯ç´æ¥è¾å ¥çï¼å¨å ¬å¼å®æåæâctrl+shift+enterâè¿ä¸é®ä¼èªå¨æ·»å ä¸ï¼ä¿ç§°ä¸é®ç»æã