Thread: ignore blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vicki Vicki is offline
external usenet poster
 
Posts: 70
Default ignore blank

column a column b column c column
d
john 3, 12 2,3
peter
Mary 12, 24 26


please help with the forumula on column d to show number "1" if column a to
c not blank

thanks again to all
--
vicki