Find the function formula of EXCEL

Hello, Du You, this problem is often encountered in practical work, and it is relatively easy to solve.

Here, 100 is taken as the benchmark price for bid evaluation to illustrate.

The formula can be used directly after being copied and pasted. The specific formula is:

= IF(B2 & gt； $C$2，MAX(30- 1 *(B2-$ C $ 2)/$ C $ 2)/ 1%)，0)，IF(B2 & lt； Canadian 2, maximum (0.30-0.5 * ($2-B2)/$2)/1%), 30))

You can continue to communicate if necessary!