Forum Discussion
david durling
May 21, 2018Copper Contributor
'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.
- Matt MickleBronze Contributor
Yes. This is possible. When multiple IF() statements are used it's referred to as nested IFs.
Here is a formula example:
=IF(C5<64,"F",IF(C5<73,"D",IF(C5<85,"C",IF(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/