Thread: [Solved] Place 0 in blank cell
View Single Post
 
Old 06-19-2014, 02:53 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
=if(isblank(n2),0,n2)

Of course, this will have to be in another cell. If you absolutely need it to be in n2, then I'm pretty sure that will require coding.
Reply With Quote