Hi , See if this is OK. If there is a problem in the calculations , upload a workbook which has data that caters to all possible variations. Narayan Thank you :) i will check this