Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

how is this function wrong in excel: ifs(COUNTIF(G:G,G2>1,1),1,T2>1,1,0)

  1. User

    how is this function wrong in excel: ifs(COUNTIF(G:G,G2>1,1),1,T2>1,1,0)

  2. Assistant

    The function you provided is incorrect because the syntax is incorrect. The correct syntax for the IFS function in Excel is:

    =IFS(logical_test1, value_if_true1, logical_test2, value_if_true2, ..., value_if_false)

    In your function, you are missing the logical_test and value_if_true arguments for each condition. Additionally, the COUNTIF(G:G,G2>1,1) part is also incorrect. Here is the corrected function:

    =IFS(COUNTIF(G:G,G2)>1, 1, T2>1, 1, TRUE, 0)

    This function checks if the count of cells in column G that match the value in G2 is greater than 1. If it is true, it returns 1. If not, it checks if T2 is greater than 1. If that condition is true, it also returns 1. If neither of the conditions are met, it returns 0.