Formula for invoice aging

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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?
 
Back
Top