EXCEL运算在选择公式之后的运算结果,如何加入小于等于IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05) 0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S4
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 12:48:08
![EXCEL运算在选择公式之后的运算结果,如何加入小于等于IF(COUNTIF(S44,](/uploads/image/z/1755675-27-5.jpg?t=EXCEL%E8%BF%90%E7%AE%97%E5%9C%A8%E9%80%89%E6%8B%A9%E5%85%AC%E5%BC%8F%E4%B9%8B%E5%90%8E%E7%9A%84%E8%BF%90%E7%AE%97%E7%BB%93%E6%9E%9C%2C%E5%A6%82%E4%BD%95%E5%8A%A0%E5%85%A5%E5%B0%8F%E4%BA%8E%E7%AD%89%E4%BA%8EIF%28COUNTIF%28S44%2C%22%2A%22%29%3E0%2CLEFT%28S44%2CFIND%28%22%2B%22%2CS44%29-1%29%2BRIGHT%28S44%2CLEN%28S44%29-FIND%28%22%2B%22%2CS44%29%29%2AU44%2A1.05%2CS44%2AU44%2A1.05%29+0%2CLEFT%28S44%2CFIND%28%22%2B%22%2CS44%29-1%29%2BRIGHT%28S44%2CLEN%28S44%29-FIND%28%22%2B%22%2CS44%29%29%2AU44%2A1.05%2CS4)
EXCEL运算在选择公式之后的运算结果,如何加入小于等于IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05) 0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S4
EXCEL运算在选择公式之后的运算结果,如何加入小于等于
IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05) 0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05)这个公式该怎么修改?
怎么才能给这段公式加入小于等于呢
IF(COUNTIF(S44,"*")>0,(LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44)))*U44*1.05,S44*U44*1.05)
小于等于R44,大于R44就按实际结果计算,
EXCEL运算在选择公式之后的运算结果,如何加入小于等于IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05) 0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S4
=IF(IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05)0,LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))*U44*1.05,S44*U44*1.05))
或
=IF(IF(COUNTIF(S44,"*")>0,(LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))),S44)*U44*1.050,(LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))),S44)*U44*1.05)
再或
=MAX(IF(COUNTIF(S44,"*")>0,(LEFT(S44,FIND("+",S44)-1)+RIGHT(S44,LEN(S44)-FIND("+",S44))),S44)*U44*1.05,R44)