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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"tom" <(E-Mail Removed)> wrote in message
news:3%Tdi.15211$(E-Mail Removed)...
>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.
>

"Don Guillett" <(E-Mail Removed)> wrote in message
news:O$(E-Mail Removed)...
>
> A simple IF function will do this. Look in the HELP index for IF
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "tom" <(E-Mail Removed)> wrote in message
> news:3%Tdi.15211$(E-Mail Removed)...
>>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.
>>
>

No if in help, I am using Excel 97.