Output Value Based on Greater than 2% Threshold

Hi All,

Hope you are doing well!...I am trying to find the maximum of the freight or cost impact based on the following set of conditions...Also attached the excel sheet..The output column is overall final attribution

1) if either costimpact or costimpact% is greater than 2% then the greater of the two percentages will be the overall final attribution -Meaning if cost is 2% and freight is 3% then freight should be the output ..
2) if both costimpact and freight impact is less than 2% then variation should be the output...
3) Also if both costimpact% and Freight impact % are the same and greater then 2% then cost should be the output..

Thanks,
Arun

Hi Ali,

This Works!..Really appreciate your help!..

Thanks,
Arun