cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

'If' formulas

david durling
Copper Contributor

‎May 21 2018 09:13 AM - last edited on ‎Jul 31 2018 08:11 AM by

‎May 21 2018 09:13 AM - last edited on ‎Jul 31 2018 08:11 AM by

'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.

545 Views
0 Likes
1 Reply
Reply
1 Reply
Matt Mickle

‎May 21 2018 11:41 AM - edited ‎May 21 2018 11:42 AM

‎May 21 2018 11:41 AM - edited ‎May 21 2018 11:42 AM

Re: 'If' formulas

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/

 

0 Likes
Reply