Why don't you write an "IF" statement in the D Cells to take care of this.

Something like this...

=IF(B2<"",D2=B2,D2=C2)

"CandiC" wrote:

I have information in columns A and B however the price is indicated in
Column A for some rows and Column B for some and in both for others. I am
interested in keeping the actual cost when available, however, when the ACT
CST is blank I would like to populate it with the STD CST stated. I would
like to merge the two colums into one As follows:

Col A ........Col B ...........Col C............Col D
Part No......STD CST......ACT CST.......Merged
152C............2.00............Blank............2 .00
153A............Blank..........7.50..............7 .50
165A............9.56...........Blank.............9 .56
175V............12.20.........12.35............12. 35
187A............Blank..........5.23.............5. 23
185A............1.25...........4.21.............4. 21

Is there a formula that can do this or would this require a macro?