在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46 蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48 绿波的数 05,06,11,16,17,21,22,27
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 15:21:37
![在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46 蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48 绿波的数 05,06,11,16,17,21,22,27](/uploads/image/z/13675068-36-8.jpg?t=%E5%9C%A8excel%E4%B8%AD%E5%A6%82%E4%BD%95%E6%8A%8A%E6%B2%A1%E8%A7%84%E5%BE%8B%E7%9A%841%E5%88%B049%E7%9A%84%E6%95%B0%E5%AD%97%E8%BD%AC%E6%8D%A2%E6%88%90%E4%B8%89%E7%A7%8D%E6%96%87%E5%AD%97%E7%BA%A2%E6%B3%A2%2C%E8%93%9D%E6%B3%A2%2C%E7%BB%BF%E6%B3%A2%3F%E7%BA%A2%E6%B3%A2%E7%9A%84%E6%95%B0+01%2C02%2C07%2C08%2C12%2C13%2C18%2C19%2C23%2C24%2C29%2C30%2C34%2C35%2C40%2C45%2C46+%E8%93%9D%E6%B3%A2%E7%9A%84%E6%95%B0+03%2C04%2C09%2C10%2C14%2C15%2C20%2C25%2C26%2C31%2C36%2C37%2C41%2C42%2C47%2C48+%E7%BB%BF%E6%B3%A2%E7%9A%84%E6%95%B0+05%2C06%2C11%2C16%2C17%2C21%2C22%2C27)
在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46 蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48 绿波的数 05,06,11,16,17,21,22,27
在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?
红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46
蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48
绿波的数 05,06,11,16,17,21,22,27,28,32,33,38,39,43,44,49
A列1-49的数字,如何在B列对应的位置自动生成红波或蓝波或绿波?
在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46 蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48 绿波的数 05,06,11,16,17,21,22,27
A1
=IF(OR(A1={1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46}),"红",IF(OR(A1={3,4,9,10,14,15,20,25,26,31,36,37,41,42,47,48}),"蓝","绿"))
下拉