Hi,

I need a formula to get two results depending on the search values of the Customer and the Revenue.

The Customer is any positive value but all values which are equal to 4 or greater are treated as 4.

The Revenue to be considered is within a range as shown in the table in column F.

So as in my example, if Customer is 2 and the Revenue is 3005 then the returned Price is 0,7 and the Bonus is 1.

Many thanks in advance