[excel] `IF` statement with 3 possible answers each based on 3 different ranges

=IF(X2>=85,0.559,IF(X2>=80,0.327,IF(X2>=75,0.255,-1)))

=IF(X2>=85,                  'If the value is in the highest bracket
      0.559,                 'Use the appropriate number
      IF(X2>=80,             'Otherwise, if the number is in the next highest bracket
           0.327,            'Use the appropriate number
           IF(X2>=75,        'Otherwise, if the number is in the next highest bracket
              0.255,         'Use the appropriate number
              -1             'Otherwise, we're not in any of the ranges (Error)
             )
        )
   )

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to if-statement

• How to use *ngIf else? • SQL Server IF EXISTS THEN 1 ELSE 2 • What is a good practice to check if an environmental variable exists or not? • Using OR operator in a jquery if statement • R multiple conditions in if statement • Syntax for an If statement using a boolean • How to have multiple conditions for one if statement in python • Ifelse statement in R with multiple conditions • If strings starts with in PowerShell • Multiple conditions in an IF statement in Excel VBA

Examples related to worksheet-function

• WorksheetFunction.CountA - not working post upgrade to Office 2010 • Excel formula to get cell color • How to find the first and second maximum number? • IF statement: how to leave cell blank if condition is false ("" does not work) • Use string value from a cell to access worksheet of same name • I want to compare two lists in different worksheets in Excel to locate any duplicates • Converting a string to a date in a cell • Refer to a cell in another worksheet by referencing the current worksheet's name? • Have Excel formulas that return 0, make the result blank • Convert date field into text in Excel