Amount calculation by different criteria

Hello Experts,

please help me to calculate following equation:

If F2 equal 2017 and E2 =< D2 then B2 equal E2*0
If F2 equal 2018 and E2 =< D2 then B2 equal E2*300
If F2 equal 2019 and E2 =< D2 then B2 equal E2*500
If F2 equal 2020 and E2 =< D2 then B2 equal E2*700

If F2 equal 2017 and E2 > D2 then B2 equal E2*200
If F2 equal 2018 and E2 > D2 then B2 equal E2*400
If F2 equal 2019 and E2 > D2 then B2 equal E2*600
If F2 equal 2020 and E2 > D2 then B2 equal E2*800

If F5 equal 2017 then D2 equal E5*100
If F5 equal 2018 then D2 equal E5*200
If F5 equal 2019 then D2 equal E5*300
If F5 equal 2020 then D2 equal E5*400

Only this equations ..

Originally Posted by farhangul

If F2 equal 2018 and E2 =< D2 then B2 equal E2*300
If F2 equal 2018 and E2 =< D2 then B2 equal E2*500
If F2 equal 2018 and E2 =< D2 then B2 equal E2*700

You have a logic problem in the way you have asked this question. These all have the same condition. You can't get three different results from the same condition.

If F2 equal 2018 and E2 > D2 then B2 equal E2*400
If F2 equal 2018 and E2 > D2 then B2 equal E2*600
If F2 equal 2018 and E2 > D2 then B2 equal E2*800

Same problem here

If F5 equal 2018 then D2 equal E5*200
If F5 equal 2018 then D2 equal E5*300
If F5 equal 2018 then D2 equal E5*400

And here.