Can you use multiple operators in a single formula?

K

Kurt

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

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top