View Single Post
 
Old 01-10-2015, 12:03 PM
Chuck_Ds Chuck_Ds is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2015
Posts: 6
Chuck_Ds is on a distinguished road
Default

Thanks a million, Charlie!! It worked! Do you have a link that explains how and why this works? That way, I'll know how to apply it to other situations. I don't recall seeing many of those characters in any of the other formulas I tried while researching this. Maybe that's why none of them worked. This works perfectly, because when '0' is entered, I want it to do that calculation (which it does!) and it ignores the blank cells (which it should!).

How does it know to differentiate between 'blank' and zero?
Reply With Quote