• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using IF statement with CONCATENATE and resulting in an error

D

dspink

New Member
Hi,

I am fairly new to the forums and fairly junior when it comes to using formula's. I have looked through previous postings and don't see anything similar - I do apologize in advance if this question is a repeat.


I am creating a tracking sheet of attendees for education courses and need to create a unique identifier - only if the person attended.


Here is the formula I tried


=IF(L7=x,CONCATENATE($F7,$L$3),0)


I keep getting an error and cannot figure out where I have gone wrong.

Thank you in advance for any assistance you can provide.
 
Hi, dspink!


Don't worry about being fairly new, just the intention matters.


I'm looking at your formula and it seems to be OK. What type or kind of error or what message error do you get? Consider uploading a sample file if necessary (give a look at the second green sticky post at this forums main page for uploading guidelines).


Regards!
 
Hi Guys,

Haseeb - thank you so much - That was exactly the issue.


I appreciate all the assistance!


have a great day
 
You must log in or register to reply here.
Back
Top