Auto add if condition is met

S

santos182

Hi

I hope you can help

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

I'll try to explain:

I have the following table. What should happen is by pressing a butto
it would automatically increase the value specified (in this case 50) t
all values in the column "Frete 20" that meet the condition of th
"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 eac
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 Argentin
 
D

Don Guillett

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
Click to expand...

I can't determine your need. If desired, send me your file and a
complete explanation
dguillett1 @gmail.com
 
Top