In excel 2007 I have used the LARGE function to return the result that I want but if the condition does not apply the cell returns #NUM! This consequently affects my conditional formatting of the results column. If the condition is not fulfilled I want to return a zero value in the cell. Help ! bearing in mind i am not a techie.