|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 4587999 于 2024-7-14 09:01 编辑
求助:
高手帮我看看我的语句哪里不对,=IF(($C$3=4)*(H13+I13=0),"NI",IF(($C$3=4)*(LOG10((H13+I13)*H12/2)-LOG10(H7)<=0.5),"NI",IF(AND(OR($C$3=1,$C$3=6),H13+I13=0),">"&ROUND(LOG10(H7)-LOG10(H12),1),IF(AND(OR($C$3=1,$C$3=6),(LOG10(H7)-LOG10(H14))<1,(LOG10(H7)-LOG10(H14))>0.49),ROUND((LOG10(H7)-LOG10(H14)),0),IF(AND(OR($C$3=1,$C$3=6),(LOG10(H7)-LOG10(H14))<0),(LOG10(H7)-LOG10(H14)),ROUND((LOG10(H7)-LOG10(H14)),1))))))
H15里面想实现,当H13和I13都是0的时候,选“USP51类型4”时显示“NI”;选“USP51类型1”或者“EP 5.1.3-3”时,显示公式里计算值。“USP51类型4”可以实现,后面的显示不出来,帮帮我,谢谢!
|
|