如:B2=1,C2=2,D2=3,在E2显示"4"(即奇数B2与奇数D2的和);B3=1,C3=5,D3=6,在E3显示"6"(即奇数B3与奇数C3的和);B4=0,C4=2,D4=6,在E4显示"0"(即没有奇数).
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 22:10:23
![如:B2=1,C2=2,D2=3,在E2显示](/uploads/image/z/8584323-51-3.jpg?t=%E5%A6%82%EF%BC%9AB2%3D1%2CC2%3D2%2CD2%3D3%2C%E5%9C%A8E2%E6%98%BE%E7%A4%BA%224%22%EF%BC%88%E5%8D%B3%E5%A5%87%E6%95%B0B2%E4%B8%8E%E5%A5%87%E6%95%B0D2%E7%9A%84%E5%92%8C%EF%BC%89%EF%BC%9BB3%3D1%2CC3%3D5%2CD3%3D6%2C%E5%9C%A8E3%E6%98%BE%E7%A4%BA%226%22%EF%BC%88%E5%8D%B3%E5%A5%87%E6%95%B0B3%E4%B8%8E%E5%A5%87%E6%95%B0C3%E7%9A%84%E5%92%8C%EF%BC%89%EF%BC%9BB4%3D0%2CC4%3D2%2CD4%3D6%2C%E5%9C%A8E4%E6%98%BE%E7%A4%BA%220%22%EF%BC%88%E5%8D%B3%E6%B2%A1%E6%9C%89%E5%A5%87%E6%95%B0%EF%BC%89.)
如:B2=1,C2=2,D2=3,在E2显示"4"(即奇数B2与奇数D2的和);B3=1,C3=5,D3=6,在E3显示"6"(即奇数B3与奇数C3的和);B4=0,C4=2,D4=6,在E4显示"0"(即没有奇数).
如:B2=1,C2=2,D2=3,在E2显示"4"(即奇数B2与奇数D2的和);
B3=1,C3=5,D3=6,在E3显示"6"(即奇数B3与奇数C3的和);
B4=0,C4=2,D4=6,在E4显示"0"(即没有奇数).
如:B2=1,C2=2,D2=3,在E2显示"4"(即奇数B2与奇数D2的和);B3=1,C3=5,D3=6,在E3显示"6"(即奇数B3与奇数C3的和);B4=0,C4=2,D4=6,在E4显示"0"(即没有奇数).
=SUMPRODUCT(MOD(B2:D2,2)*B2:D2)