Auto add if condition is met
 

Hi

I hope you can help

I want to add a certain value to all cells when a certain condition is met.

I'll try to explain:

I have the following table. What should happen is by pressing a button it would automatically increase the value specified (in this case 50) to all values in the column "Frete 20" that meet the condition of the "Pais" being, in this case, "Angola".

The same should happen for each column (Frete; BAF; CAF;...)


País Frete 20 BAF 20 CAF 20 PSS 20
Angola 20 30 40 50


So when clicking the button it would add the corresponding value to each column

POL País Validade Frete 20 BAF 20 CAF 20 PSS 20
Cape Town Africa do Sul
Durban Africa do Sul
East London Africa do Sul
Johannesburg Africa do Sul
Port Elizabeth Africa do Sul
Pretoria Africa do Sul
Cabinda Angola
Lobito Angola
Luanda Angola
Namibe Angola
St. John's Antigua
Damman Arabia Saudita
Jeddah Arabia Saudita
Riyadh Arabia Saudita
Alger Argelia
Algiers Argelia
Buenos Aires Argentina