Thanks all, have got this sorted now- works a treat x

"Debra Dalgleish" wrote:

Or, to return an empty string, which would make the cell look blank:

=IF(ISNA(YourFormula),"",YourFormula)

Niek Otten wrote:
=IF(ISNA(YourFormula),0,YourFormula)



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html