+ Reply to Thread
Results 1 to 4 of 4

IF Formula Population Help

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2010
    Posts
    6

    IF Formula Population Help

    i am using this formula to populate an "all presenters" column from the "lead presenter" and "additional presenters" columns. the problem is that "all presenters" will not populate unless there is a value in "lead presenter". i'd like it to populate even if there is only a value in "additional presenters".

    i did not write the formula, and am only beginning to scratch the surface, thank you for any/all help.

    =IF([Lead Presenter]<>"","LEAD: "&[Lead Presenter]&IF([Additional Presenters]<>""," | "&"ADDL: "&[Additional Presenters],""),"")

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: IF Formula Population Help

    Maybe something like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: IF Formula Population Help

    it works, i see the code, but can you explain to me what it is saying?

    thank you very much for your help!

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: IF Formula Population Help

    Okay I'll do this in 2 parts
    Part 1, The Original Formula:
    Basically this says that if there is a Lead Presenter, display the name, then if there are additional presenters, display them as well:
    if there is NO lead presenter, display nothing

    Part 2, Revised Formula:
    Basically this says that if there is a Lead Presenter, display the name, then if there are additional presenters, display them as well:
    if there is NO lead presenter, check to see if there are additional presenters, if there are, display them, if not display nothing

    Compare the 2 formulas and you can see what I changed (where the second set of ,"") at the end were), this is where the formula goes when there is no lead presenter...

    Hope that was understandable

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1