Results 1 to 16 of 16

Need help - Multiple if function

Threaded View

  1. #8
    Registered User
    Join Date
    09-26-2016
    Location
    Santa Rosa, CA
    MS-Off Ver
    MS 2013
    Posts
    12

    Re: Need help - Multiple if function

    Thanks for simplifying it. That is unfortunately not the formula I am looking for. Here is the sample excel sheet. Class attendance shows all students' attendance based on their school district. The tab on the very left shows their attendance for a specific school district. The SELPA for is a government form that cannot be changed. Therefore, I am trying to write a formula to auto populate students attendance for that school district.

    Please see my notes in the workbook.

    Thanks
    Quote Originally Posted by Sambo kid View Post
    So if I understand correctly, you want something like this... =IF(A1="Wright School District",A2,"")
    Since I don't know how good your skills are in excel, begin this way
    Click in the cell you want the results in, hit the = sign, then put IF and a left parens "(" then go to the sheet where the school district is and click in cell A1 then add the equal sign and type in quotes the school district name, then add A2 and then the blank quotes then close the parens and it should be the formula you want based on what you wrote in post 6. If that isn't what you want you might need to give more detail or post a sample sheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to output multiple results of a single function by running the function only once
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2016, 07:24 PM
  2. If function + Find Function to search for multiple values
    By HabsFan89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2015, 12:11 PM
  3. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  4. Vlookup function to return multiple values from multiple sheets
    By bsamant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 11:31 AM
  5. Multiple Criteria Function along with Count function
    By Joseph Wee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2013, 12:51 AM
  6. Need help to change multiple criteria from if function to Case function.
    By indkitty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 10:42 PM
  7. Replies: 5
    Last Post: 01-20-2009, 11:56 AM

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