Forum Discussion

david durling's avatar
david durling
Copper Contributor
May 21, 2018

'If' formulas

Is it possible to have a formula that consists of two 'if' formulas? That is check a cell first and then if a certain value then apply another 'if' formula.

Formulas & Functions
Need Help

1 Reply

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 21, 2018

    Yes.  This is possible.  When multiple IF() statements are used it's referred to as nested IFs.

     

    Here is a formula example:

     

    =https://exceljet.net/excel-functions/excel-if-function(C5<64,"F",https://exceljet.net/excel-functions/excel-if-function(C5<73,"D",https://exceljet.net/excel-functions/excel-if-function(C5<85,"C",https://exceljet.net/excel-functions/excel-if-function(C5<95,"B","A"))))

     

    You can review the formula explanation at this link: 

    https://exceljet.net/formula/nested-if-function-example

     

    Newer Versions of Excel also have an IFS() function which can evaluate multiple conditions without nesting: 

     

    Here is some information on this function:

    https://www.ablebits.com/office-addins-blog/2016/07/21/function-ifs-excel2016/

     

Resources