If Statement Question

[tridino]

Hello,

I have the following formula for cell B2:

=if(A2="Name Change","","N/A")

However, I also want B2 to be blank if A2 is also blank. I can't seem to figure out how to do this - i'm pretty new to nesting formulas.

Any help? Thank you.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=if(or(A2={"Name Change",""}),"","N/A")

 

[tridino]

Hi & welcome to MrExcel.
How about

=if(or(A2={"Name Change",""}),"","N/A")

Thanks, worked!

 

[Fluff]

You're welcome & thanks for the feedback.