B1公式:=if(A1<=8,"1/1","1/2")C2公式:=if(A1<=8,"1/1","2/2")
B1公式:=1/IF(A1>8,2,1)C2输入:1下拉。
在B1中输入=IF(A1<=8,"1/1","1/2")在C2中输入=IF(A1<=8,"1/2","2/2")
B1输入公式:=1/IF(A1>8,2,1)。C1输入公式:=IF(A1>8,2,1)/IF(A1>8,2,1)