The column K one is fairly easy. IN K2: =IF(AND(ISNUMBER(B2),NOT(ISBLANK(B2))),1,10)
With regards to column J, I"m sure there is an elegant way, but to be honest, I'd probalby just go with the nested IF statements. Yes, it will be ugly, but it's probably going to be a lot easier to build and maintain than an elegant formula. (Having said that, Bob Phillips will probably come along and post a really short version to accomplish it.![]()
Bookmarks