LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 47
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I rank values in multiple subsets using a single formula? brianalucas Excel Discussion (Misc queries) 4 December 17th 07 06:03 PM
Ranking values in multiple subsets using one single formula brianalucas Excel Discussion (Misc queries) 1 December 14th 07 08:08 PM
Printing single pages from multiple worksheets in a single print job [email protected] Excel Discussion (Misc queries) 2 April 27th 07 06:11 PM
Find Multiple instances of Single Criterion in Row & Return To a Single Col Sam via OfficeKB.com Excel Worksheet Functions 16 May 10th 06 03:00 AM
Multiple lookup in a single formula .. sansk_23 Excel Worksheet Functions 2 May 26th 05 11:50 AM


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"