å ³é®æ¯ç¬¬ä¸ä¸ªâsheet1âè¦åæ£ç¡®ãæ¹æ³ï¼
å设å¨sheet1ä¸æå¦ä¸ä¸ä¸ªè¡¨ï¼è®©è¡¨æ ¼èªå¨å¨Aåä¸æ±å计ç®
1ãé¼ æ å·¦é®ç¹å»A2ï¼å¨ç¼è¾æ ä¸è¾å ¥â=B2+C2âï¼ç¶åéæ©âââã
A2ä¸ä¼å¾åºå8ã
2ãå¤å¶A2ï¼ç²è´´å°A3ãA4......ã以æ¤ç±»æ¨ï¼Aåçåå æ ¼åå«å°±æ¯âa=b+câäº
sheet1çè¡¨æ ¼å¶ä½å®æ¯ï¼ä¸é¢åsheet2æ·è´
3ãé¼ æ å·¦é®ç¹å»sheet1è¡¨æ ¼å·¦ä¸è§ï¼è§å¾ä¸çº¢ç®å¤´ï¼éä¸å ¨é¨è¡¨æ ¼ã
ç¶åé¼ æ å³é®ï¼éæ©âå¤å¶âã
4ãæå¼sheet2ï¼é¼ æ æåè¡¨æ ¼å·¦ä¸è§ï¼å³é®æå¼èåï¼éæ©âç²è´´âï¼è¡¨æ ¼å°±å¤å¶å°sheet2ä¸äºã
ç¹å»ä¸ä¸A3ï¼æ£æ¥ä¸ä¸æ¯å¦å ¬å¼å¨âå¤å¶ââç²è´´âè¿ç¨ä¸ä¸¢å¤±ã
å¨ç¼è¾æ ä¸æ¾ç¤ºA3â=B3+C3âï¼è¯´æå ¬å¼å·²ç»éååè¡¨æ ¼è½¬ç§»è¿æ¥äºã