Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· openaiHugging Face Suzhen/CodeChat

Google Sheet formula for IF Margin is positive, then IFS formula kicks in

  1. User

    Google Sheet formula for IF Margin is positive, then IFS formula kicks in

  2. Assistant

    You can use the following formula in Google Sheets to check if the margin is positive. If it is positive, an IFS formula will be triggered, otherwise, it will return a blank or any other specified value:

    =IF(A1>0, IFS(B1>100, "High", B1>50, "Medium", B1>0, "Low"), "")
    

    In this example, A1 represents the margin value, and B1 represents any value you want to evaluate using the IFS formula. Adjust the cell references and conditions according to your specific data.