IF formula Error, blank cells

[sk8shorty01]

Hello all,

I am trying to write an IF statement that will help me combine a few columns I have but for some reason I cannot figure out how to get this to work. The formula I have written is:

Please Login or Register  to view this content.

Now what I am trying to get the code to do is to:

Look at Column AV3, if blank make AX3 equal AW3, if anything else Concatenate AV3 and AW3 (with comma space in between) and again make AX3 equal the concatenation of the two.


I thought I could figure it out on my own but I am a little too green to figure it out, I think I am on the right track but any help would be appreciated.

I had the code above in AX3, as that is where I would like the outcome to be displayed.


Thank you,

Mike

[Andrew-R]

Your formula is fine, except that you don't need the = sign immediately before CONCATENATE.

Take that out and you're there.

[sk8shorty01]

Thank you very much.