mutliple conditions
 

Need to add to this formula to first check the value in cell(h3) if it is a
credit do not use the formula below and return the value in H3, if the value
is greater than 0 use this formula

=IF($Q$2=($G3+1),IF($Q$2<=($G3+30),$H3,""),"")

Q2 is a user entered date and g3 is the invoice date, H3 is the invoice
amount.

mutliple conditions
 

assume credits are negative
=if(h3<0,h3,if(and($Q$2=$G3+1,$Q$2<=$G3+30),h3,"" ))

Or

if(or(h3<0,and($Q$2=$G3+1,$Q$2<=$G3+30)),h3,"")

Let me know if that helps....
--
Wag more, bark less


"Sue" wrote:

Need to add to this formula to first check the value in cell(h3) if it is a
credit do not use the formula below and return the value in H3, if the value
is greater than 0 use this formula

=IF($Q$2=($G3+1),IF($Q$2<=($G3+30),$H3,""),"")

Q2 is a user entered date and g3 is the invoice date, H3 is the invoice
amount.