+ Reply to Thread
Results 1 to 7 of 7

Need formula to return a desired response

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Buffalo, New York
    MS-Off Ver
    Excel 2007
    Posts
    11

    Exclamation Need formula to return a desired response

    I currently have this formula and it is not working.

    =COUNT(I24:U24, I24=0.143,K24=0.285,M24=0.429,O24=0.571,Q24=0.714,S24=0.857,U24=1)



    In columns I24:U24 an "x" or "1" can be entered. I am trying to produce a formula that would result in the desired integer noted above. Thus if you place an "x" or "1" in one of the cells I24:U:24 cell X24 would return the corresponding integer. Example: An "X" or "1" in cell M24; would yield in cell X24 0.429. Please help.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Need formula to return a desired response

    Could you please attach an example of you workbook?

    Thanks!

  3. #3
    Registered User
    Join Date
    12-15-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Need formula to return a desired response

    Might want to change your subject to something more descriptive and also post a sample workbook.

  4. #4
    Registered User
    Join Date
    05-02-2012
    Location
    Buffalo, New York
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Need formula to return a desired response

    See attachment and highlighted area
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Need formula to return a desired response

    The Formula for X24

    =IF(OR(I24=1,I24="x"),0.143,IF(OR(K24=1,K24="x"),0.285,IF(OR(M24=1,M24="x"),0.429,IF(OR(O24=1,O24="x"),0.571,IF(OR(Q24=1,Q24="x"),0.714,IF(OR(S24=1,S24="x"),0.857,IF(OR(U24=1,U24="x"),1)))))))

    Thanks,

    RVASQUEZ

  6. #6
    Registered User
    Join Date
    12-15-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Need formula to return a desired response

    Try this:

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-02-2012
    Location
    Buffalo, New York
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Need formula to return a desired response

    Thank you soo much!!!!!!

+ 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