Help in calculating tax % for CO2 emissions - part 2?

[Riki]

Thank you Jacob Skaria for already answering this question. But change of in
condition happened.Please also see the bottom of the page for description of
the change.

From previous posts:

Once you get in the % based on CO2 emission...use the below formula to add
the condition based on column C and Column D

In E2
=<your formula> + LOOKUP(C2,{0,3,4,5},{3,2,1,0}) + IF(D1="Y",2,0)

If you break it down
=LOOKUP(C2,{0,3,4,5},{3,2,1,0}) will return the additional % based on
emission level and
=IF(D1="Y",2,0) will return 2 for diesel

I would suggest using a LOOKUP rather then using multiple IF conditions in
your formula.


If this post helps click Yes

CHANGE IS FOLLOWING: If in column C value is >4 and engine is diesel, tax
degree for GASOLINE engines (table above) is applied.

Thank you for all your help.