Forum Discussion

cnoah92's avatar
cnoah92
Copper Contributor
Jul 12, 2025

logical function

I have tried building a logical function that can help me calculate the exact values in the Score column. This can help me calculate for large data. values under the score section are the criteria that is reach if any of the conditions under the 6 disability domains is met. I need help please  

Formulas and Functions

6 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Jul 14, 2025

    Depends on some of those definitions but it appears and 'A lot' or 'Unable' results in YES and the rest are ignored except if all the values are 'Missing' then return 'Missing'.  Here is my solution:

     

    =IFERROR(IF(AVERAGE(XLOOKUP(UPPER(B3:G3),UPPER($K$2:$K$6),$L$2:$L$6)),"Yes","No"),"Missing")

     

     

    • cnoah92's avatar
      cnoah92
      Copper Contributor
      Jul 15, 2025

      Thank you very much for your response. Actually, I want a formula that get me the same values in the score column. Those values in the score column are constant base on the respondent response under each of the disability domains. 

      • m_tarler's avatar
        m_tarler
        Bronze Contributor
        Jul 15, 2025

        I don't understand.  The formula I gave takes the responses from the 6 disability domains and produces the Yes/No 'Score' and in every case in your table my formula produced the SAME Score as you had listed.  Your Score in column H and my formula in column I.  I thought I attached the sample file but I will try again here.

        If you feel my formula is not accurate, please let me know why or what other considerations are needed.  I can only go on the information you provide.

Resources