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.
A simple IF function will do this. Look in the HELP index for IF

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>I want a cell to display only if it matches certain criteria.
>
[quoted text clipped - 6 lines]
> 45, then cell e2 should display $100.00, and if c2 says
> 65 then f2 should display $100.00 and e2 should be blank.
tom - 19 Jun 2007 18:29 GMT
> A simple IF function will do this. Look in the HELP index for IF
>
[quoted text clipped - 8 lines]
>> 45, then cell e2 should display $100.00, and if c2 says
>> 65 then f2 should display $100.00 and e2 should be blank.
No if in help, I am using Excel 97.