There's also some discussion about IF in the comments at http://www.dailydoseofexcel.com/arch...e-excel-crash/