Formula for invoice aging

[Michelle]

If a number in a cell is less than, but greater than (30-
60 days past due), return this cell, if not "zero". ie =IF
(G3>30,H3,0):IF(G3<61,H3,0), this formula enters "#value"
in the cell it is not true in. How do I fix it to
enter "0" in those cells it is not true?

 

[dizzykid]

Try it this way:
=IF(AND(G3>30,G3<61),H3,"")

HTH
Chris