Search code examples
excelif-statementformula

Excel nested IF function

I'm having trouble with a nested IF function. I want to assign a "T" value to a cell based on its number value between a Max and Min number. The number resides in cells within Column H. However when I nest the function I encounter the #Value! error Can anyone highlight my flaw?

=IF(AND(H2>=MIN(8),H2<=MAX(15)),"T-2",),IF(AND(H2>=MIN(0),H2<=MAX(7)),"T-1",)

Solution 
  • =IF(AND(H2>=0,H2<8),"T-1",IF(H2<=15,"T-2",""))