The first formula:
(If "auto" and possibly other text in the same cell is found, then Q33+Q37; otherwise Q34+Q37.
This formula works fine on its own.
The second formula:
(First find the value and substract this from 1, then divide this result with the same found value again, then finally add 1.)
When combining the two formulas, I need this:
1. No value error or similar should be printed (empty target cell if can't calculate). In other words, IFERROR needs to be added.
2. The result of the first formula should be multiplied with the result of the second formula.
An example of real values:
Q33 contains 12.6, Q34 contains 11.9, P33 contains "auto" (so use value in Q33), Q37 contains -0.3, K4 contains 1640 which is the lookup value in Travbanor! and which returns 0.914.
The result then would be this for formula one: 12.6-0.3=12.3
The result then would be this (or should be if the formula is correct) for formula two: 1-0.914=0.086, 0.086/0.914=0.094, 0.094+1=1.094.
The final result when the two formulas are combined would be 12.3*1.094=13.5.