hi Steve,

Thanks for the quick one.. The condition when F2 < 7 returns #Value..

I've tried my best, but couldn't debug.. Appreciate your help.. thanks