Basic If/Replace Question

[Gamermatt]

Hello,

I have a list of prices in column A. Then in column B, the cells either says DELETE or is blank. I need to put code into column C, that copies the cells from column B, and replaces the cell with the value 0, if the cell in column B says DELETE. How would I go about doing this?

Thanks in advanced.

Matt

 

[rallcorn]

When you say "replace" do you mean in column C (not replace it in the original Column A price list)?

If so, the column C formula would be:
=if(B1="DELETE",0,A1)

 

[Gamermatt]

When you say "replace" do you mean in column C (not replace it in the original Column A price list)?

If so, the column C formula would be:
=if(B1="DELETE",0,A1)

Alright thanks, thats easier than I thought