Excel如果A>1,则B,A>1且A<=2,则C,A>2且<=3,则D,A>3且<=5,则E 的公式怎么写?
Excel如果单元格A=1,则单元格B,单元格A>1且单元格A<=2,则单元格C,单元格A>2且<=3,则单元格D,单元格A>3且<=5,则单元格E 的公式怎么写?
åºè¯¥æ¯è¿æ ·çï¼å¦æåå æ ¼A=1ï¼åæ¾ç¤ºåå æ ¼Bçæ°åï¼åå æ ¼A>1ä¸åå æ ¼A2ä¸3ä¸<=5,åæ¾ç¤ºåå æ ¼E æ°åçå ¬å¼æä¹åï¼
追ç=IF(A1<1,"",IF(A1=1,B1,IF(A1<=2,C1,IF(A1<=3,D1,IF(A1<=5,E1,"")))))