View Single Post
  #3   Report Post  
Paul Black
 
Posts: n/a
Default

Hi GSingh,

In Cell "C1" for Example Enter the Formula :-
=IF(B1="",A1,IF(B1=0,A1,0))

All the Best.
Paul