Read all -- Adding columns for paying

K

Katherine

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 --
 
T

Tom Ogilvy

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

or use OR as Frank suggested:

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

Frank Kabel

Hi Tom
you don't give up, do you :))

@Katherine: If these functions do not work for you please provide an
example of your data, stae what our functions have returned and what
your expected result would be. I think Tom + I agree that either of
these formulas should work
 
Top