|
|
#3
01-23-2018, 04:37 PM
|
|||
|
|||
Lookup to find first non-blank cell
Jeffery - OK that works - but why???
I did find that the column is really not blank cells - it has spaces. The formula for column N is =IF(B14=" "," ",D14+E14+H14) which is inserting a space. What is the 9.99999999999999E+307 doing? Why 307? Thanks for your help! Mike 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Lookup and replace cell values | rgauss | Excel | 3 | 10-03-2016 04:01 PM |
| LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
 Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
|
Place 0 in blank cell
|
mbesspiata | Excel | 5 | 06-20-2014 07:00 PM |
| won't show blank cell | bhum | Excel | 2 | 01-28-2014 02:34 AM |
Windows 10 
Office 2010 64bit
Threaded Mode