在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?
发布网友
发布时间：2022-04-23 03:11
共2个回答
热心网友
时间：2023-10-12 22:55
B1=lookup({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},{"红波";"蓝波";"绿波"})下拉填充
热心网友
时间：2023-10-12 22:55
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}),"蓝","绿"))
下拉
