作业帮 > 综合 > 作业

四位数字的余数码的公式

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/09 08:58:37
四位数字的余数码的公式
A1单元格里有个四位数,如1234;B1单元格里有个四位数,如3456 要在C1中显示余数码0789(即,在0到9中去掉123456,剩下的数字就是余数码)……感谢各位帮忙!
这种问题下回请分类到计算机软件excel中
=IF(ISERROR(SEARCH("0",A1&B1)),"0","")&IF(ISERROR(SEARCH("1",A1&B1)),"1","")&IF(ISERROR(SEARCH("2",A1&B1)),"2","")&IF(ISERROR(SEARCH("3",A1&B1)),"3","")&IF(ISERROR(SEARCH("4",A1&B1)),"4","")&IF(ISERROR(SEARCH("5",A1&B1)),"5","")&IF(ISERROR(SEARCH("6",A1&B1)),"6","")&IF(ISERROR(SEARCH("7",A1&B1)),"7","")&IF(ISERROR(SEARCH("8",A1&B1)),"8","")&IF(ISERROR(SEARCH("9",A1&B1)),"9","")