如题所述
excelåªè½æ§è¡æé»è¾ï¼é¢è®¾çæ°æ®ï¼èªç±å¤ææ¯æ¯è¾é¾ç ã
é¦å éè¦ä¸ä¸ªè§åï¼ç»ä¸ªä¾åï¼ä½ èªå·±åèå§ã
以ç»å°æå计ç®çç两ä½æ°çå åæ³ä¸ºä¾ï¼
=RANDBETWEEN(1,100)&INDEX({"+","-"},RANDBETWEEN(1,2))&"("&RANDBETWEEN(1,100)&INDEX({"+","-"},RANDBETWEEN(1,2))&RANDBETWEEN(1,100)&")"
éé¢é½æ¯æ¨¡ååçï¼èªå·±å¯ä»¥è°æ´çã
æ¯ä¸ä¸ª & 符å·é离å¼ä¸ä¸ªåè½ã
ææå¦ä¸å¾ï¼
90-(97+74)
4+(19+38)
49-(32-5)
å¦æéè¦1ä½æ°ï¼RANDBETWEEN(1,9) å³å¯ã
éè¦å åä¹é¤ï¼åè
INDEX({"+","-","Ã","÷"},RANDBETWEEN(1,4)
é¦å éè¦ä¸ä¸ªè§åï¼ç»ä¸ªä¾åï¼ä½ èªå·±åèå§ã
以ç»å°æå计ç®çç两ä½æ°çå åæ³ä¸ºä¾ï¼
=RANDBETWEEN(1,100)&INDEX({"+","-"},RANDBETWEEN(1,2))&"("&RANDBETWEEN(1,100)&INDEX({"+","-"},RANDBETWEEN(1,2))&RANDBETWEEN(1,100)&")"
éé¢é½æ¯æ¨¡ååçï¼èªå·±å¯ä»¥è°æ´çã
æ¯ä¸ä¸ª & 符å·é离å¼ä¸ä¸ªåè½ã
ææå¦ä¸å¾ï¼
90-(97+74)
4+(19+38)
49-(32-5)
å¦æéè¦1ä½æ°ï¼RANDBETWEEN(1,9) å³å¯ã
éè¦å åä¹é¤ï¼åè
INDEX({"+","-","Ã","÷"},RANDBETWEEN(1,4)
温馨提示:答案为网友推荐,仅供参考