Display cell that matches criteria

[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.

 

[Don Guillett]

A simple IF function will do this. Look in the HELP index for IF

 

[tom]

A simple IF function will do this. Look in the HELP index for IF

No if in help, I am using Excel 97.