Your first formula outputs a number or null into H5. A null is not the same as no data and has a non-zero value. Accordingly, your subsequent formula needs to test for nulls (i.e. "") as well.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|