Welcome to the forum!

That looks like an 18 IF()s formula. The easier route would be to use a macro as a worksheet change event to do the check.