I have no idea about the constant values in your formula, i.e, 15*0.153*25+4*0.153*12,
but all of them are smaller 100, except the last one: 11*0.153*22+25*0.153*35 = 170.901 (in condition of no " topped" found in Input!B2 and V22<>"*"
Therefore below formula has same result with #2 one:
![]()
=IF(AND(ISERROR(SEARCH("Topped",Input!$B$2)),V22<>"*"),170.901,100)
Bookmarks