Makro/VBA to sum up with if then"

[Desireea]

Hi,

I'm trying to create a formula which will check is there indicator A or B and then on the basis of that will add plus 20 (A) or 30(B) to cell balance the result will be in output. How to create that in VBA?

A B C
Sector Balance Makro Output
A 60 should be 60+20
B 23

Thanks in advance

 

[Ruddles]

Welcome to the forum!

Does it have to be a macro? A formula would be so much simpler...