Concatenate cells and replace if a particular cell is blank

[bloodlvst]

Hello! I have a group of cells I'm concatenating and my formula is working great. The issue I'm having is that one of the fields I'm pulling from is sometimes blank until it's updated later on. I'd like it so that if the field is blank, it enters my "PENDING" text. Examples below:

My formula is: =CONCATENATE(A1,", ",A2, " - ",C1)

What I currently have:

	A	B	C	D	E
1	Smith	John	1044		Smith, John - 1044
2	Rodgers	Aaron			Rodgers, Aaron -
3	Lucas	Spencer	1087		Lucas, Spencer - 1087
4	Banjo	Shawn			Banjo, Shawn -

What I'd like to happen:

	A	B	C	D	E
1	Smith	John	1044		Smith, John - 1044
2	Rodgers	Aaron			Rodgers, Aaron - PENDING
3	Lucas	Spencer	1087		Lucas, Spencer - 1087
4	Banjo	Shawn			Banjo, Shawn - PENDING

I know it involves an IF and I've tried, but I tend to mess stuff up when I start trying to nest functions. Which is what's happening now. Any suggestions would be greatly appreciated

[Special-K]

=concatenate(a1,", ",a2, " - ",if(c1<>"",c1,"pending"))

[Ron Coderre]

Try something like this, copied down

Please Login or Register  to view this content.

Is that something you can work with?

[bloodlvst]

Thank you both so much for your help! Working perfectly now! :D