T
tom
I want a cell to display only if it matches certain criteria.
Basically, I am trying to display invoices that are
30, 60 and 90 days over due. I want the cell only
to display invoice amount if the aging falls within
the correct dates.
For example if cell b2 says $100.00 and cell C2 says
45, then cell e2 should display $100.00, and if c2 says
65 then f2 should display $100.00 and e2 should be blank.
Basically, I am trying to display invoices that are
30, 60 and 90 days over due. I want the cell only
to display invoice amount if the aging falls within
the correct dates.
For example if cell b2 says $100.00 and cell C2 says
45, then cell e2 should display $100.00, and if c2 says
65 then f2 should display $100.00 and e2 should be blank.