求会计excel高手,图片中“是否合算”,“最佳方案”的函数公式怎么计算,求高手

2024-12-21 11:11:10
推荐回答(1个)
回答1:

=if(B9=min($B$9:$E$9),"合算","不合算")

=if(B11=min($B$11:$E$11),"最佳方案","")