If Statement with blanks and do nothing

Hi,

I am trying to create an if statement where i want to change the "Issue Type" to say "New Feature" when the corresponding value in the Category column is "Enhancement". How can we write the formula is a way that it takes into consideration the blanks in column C and that if it doesn't say "Enhancement in column C then leave whatever is in Column B.

Ex. in the attached ample sheet, for B3 and B6 it would say "New Feature" and the rest of the values in Column B would remain as is.

Any assistance would be appreciated.

Thank You!

Hmm that seems to be only a part of what im looking for. How can only B3 and B6 say "New Feature" but then B1, B2, B4, B5 says Issue, Idea, Issue, Bug, Bug respectively --essentially, remain the original value.

Hi,
I dont think you can run over the values within column B, if that's what you mean.
You can apply the formula in column D and create an adjusted "Issue Type" as follows:

In D2:
=IF(C2="Enhancement", "New Feature",B2)