EXCEL运算在选择公式之后的运算结果,如何加入小于等于IF(COUNTIF(S44,"*")>0,LEFT(S44,FIND("_其他解答

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就按实际结果计算,

人气：484 ℃　时间：2020-04-21 23:13:19

解答

=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)