假如:1.买饮料一箱,送可乐1瓶。 2.买饮料二箱,送女儿红黄酒1瓶。买三箱酒一瓶,加可乐一瓶。买四箱,送酒2瓶。
=IF(A2>=2,"送女儿红黄酒"&INT(A2/2)&"瓶"&IF(MOD(A2,2),"+可乐1瓶",""),IF(A2>=1,"送可乐1瓶",""))