View Single Post
  #6   Report Post  
galimi
 
Posts: n/a
Default

=if(isna(cell_ref),0,cell_ref)

Replace cell_ref with the one cell range being referenced

http://HelpExcel.com

"neilcarden" wrote:


Thanks again you guys!!! Excellent...


--
neilcarden