View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Read all -- Adding columns for paying



=if(and(A2="",B2=""),0,B2-A2+1)

or use OR as Frank suggested:

=if(OR(A2="",B2=""),0,B2-A2+1)



--
Regards,
Tom Ogilvy


"Katherine" wrote in message
...
The add one will not work because it will add one to those
persons who have no payment coming - I have to have a way
to identify that the one is added only to those that have
earned payment --