Hi,

Help in building macro with to enter formula inside a IF condition.

Eg 1 - If A2=a and B2=x then D **=C2*20** (it is a formula)

2 - If A3=a and B3=y then **D =C3*15** (it is a formula)

Similarly for other combinations range should be in a loop.

Thanks in Advance.