=IF(COUNTIF(A2:I2,"High")>0,"High",IF(AND(COUNTIF(A2:I2,"Low")>0,COUNTIF(A2:I2,"High")=0),"Low","Medium"))
=IF(COUNTIF(A2:I2,"High")>0,"High",IF(AND(COUNTIF(A2:I2,"Low")>0,COUNTIF(A2:I2,"High")=0),"Low","Medium"))
Shorter ..
=IF(COUNTIF(A2:I2,"High"),"High",IF(COUNTIF(A2:I2,"Low"),"Low","Medium"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks