![]() |
#3
|
||||
|
||||
![]()
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] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
![]() |
jprt68 | Excel | 1 | 06-26-2012 08:31 AM |
![]() |
etodem | Excel | 2 | 10-23-2010 07:33 PM |
![]() |
markg2 | Excel | 4 | 05-24-2010 11:50 AM |