Double IF Then Concatenate Scenarios

Hi guy's I have a really simple problem here

I am looking to concatenate based off of 2 different values.

for instance

Double if(concatenate.jpg

I need all of the Cells in Column C to copy Column B and add a -R

If I use this formula in cell C1 then It will populate everything except for the cells in columns A that have the text 617.


=IF(A1=139973,CONCATENATE(B2,"-R"))

I have also attached the file

Put this in C2:

=IF(OR(A2="",A2=617),"",B2 & "-R")

then copy down as far as you like.

Hope this helps.

Pete

I pasted the above formula and this is the results

Double if(concatenate.jpg

I can't read your screenshot.

Does it do what you wanted? If it does, then you can mark this thread as solved (see below). If it doesn't, you need to describe your requirements more clearly.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

I apologize, The rows that contain 617 are being left blank while the other ones are populating correctly

Originally Posted by MusicJunky

... The rows that contain 617 are being left blank while the other ones are populating correctly

I thought that was what you were asking for in your first post. Use this instead in C2:

=IF(A2="","",B2 & "-R")

Hope this helps.

Pete