If statement adding calculations

[ds0919]

Hello,

I have a monthly report that I want to create a macro to do the following:

If column "B" has a certain name, then change column H to be a calculation - the calculation would be =f2*.70. I will have a similar calculation in column I as well, which should be =g2*.70. (in both, where "2" would be the appropriate row)

But if column B has any other name, leave column H as it is. (It will already be populated with a number that I need to keep.)

There are 4 names that I will need to use the same calculation for. All of the other rows should not be changed. I am attaching a copy of the spreadsheet with the 4 names highlighted.

Any help would be greatly appreciated. I hope my intent is clear.

Thanks!!

[Jacc]

Is this what you want?

[ds0919]

Jacc,

That's close.

I don't want to insert new columns. If one of the 4 departments is identified, I want to use the formula (g2*.7 and h2*.7) to calculate the amount instead of the zeros that are in the corresponding fields on columns H and I. (F2*.7 - the value would go in the "Cost with All Rebates - Current" column.) (G2*.7 - the value would go in the "Cost with all Rebates-Prior" column.)

If one of those departments is not identified, I want to leave the numbers as they are in columns H & I.

So for Cold Dispensed Bev:

H should be $ 141.15
I should be $ 167.92

I hope that clarifies it some.

[Jacc]

A cell can contain either data or a formula, not both (unless you want to manually type in the formulas with data in it in each cell). Adding columns with formulas is usually how tasks like this is done. While it is possible to make a macro that does not insert columns it would be totally overkill for this task, not worth the extra effort if you ask me.
I have a hard time following your reasoning. If you could take the original workbook and make some calculation examples and some comments of what you want I will try.