Can you use multiple operators in a single formula?

I am trying to write a formula that returns the results of 90 Days, 60 Days,
30 Days and Current based on outstanding invoices. I have an age of invoice
cell that tells me the age of the invoice and i want to write a formula from
that cell telling me from the current date which category they fall into.
Any help would be appreciated.

GarysStudent
Thu Mar 13 16:16:01 CDT 2008

=IF(TODAY()-A1>90,"90 day",IF(TODAY()-A1>60,"60 day","30 day"))

--
Gary''s Student - gsnu200773

Sandy
Thu Mar 13 16:48:12 CDT 2008

I read your post slightly different to Gary"s Student.

> cell that tells me the age of the invoice

If by this you mean it contains the number of days old the Invoice is then
try:

=IF(E15<30,"Current",CEILING(E15+1,30)-30&" Days")

If Gary"s Student is right and the cell contains a date then try:

=IF(TODAY()-D15<30,"Current",CEILING(TODAY()-D15+1,30)-30&" Days")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk


"Kurt" <Kurt@discussions.microsoft.com> wrote in message
news:7F59D71F-8FE5-4ECB-B8D9-99F16B885A0B@microsoft.com...
>I am trying to write a formula that returns the results of 90 Days, 60
>Days,
> 30 Days and Current based on outstanding invoices. I have an age of
> invoice
> cell that tells me the age of the invoice and i want to write a formula
> from
> that cell telling me from the current date which category they fall into.
> Any help would be appreciated.
>