Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krish
 
Posts: n/a
Default TRUE/FALSE

Back in Novemeber I posted this question and I got the reply, which helped
meet my need. But after my computer hard drive crash, I lost the
spreadsheet. Can I request one more time for the answer? Also in the list if
I introduce a field for date of the Invoice, what would be the formula to
distinguish, the date?

I have a list in a spreadsheet as follows. I want a formula to fill the
Criteria column. The condition should be
a.. Invoice dollars should be less than $ 200 and
b.. if there are two Invoices for the same customer and if the sum of all
Invoices is still less than $ 200, it should reflect as "TRUE" for both
Invoices.
c.. If the dollar amount of an Individual Invoice or sum of all Invoices
for a customer is greater than $ 200, it should reflect as "FALSE"
Invoice Customer Sales Criteria
W112311 CRE100 799.15
W112344 CRE100 185.42
W112345 DRW200 199.49
W112452 HLE300 129.95
W112457 HLE300 41.54

How can I accomplish the multiple conditions in one formula?

Thanks.


 
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
Indexing/Matching True/False results drvortex Excel Worksheet Functions 5 November 29th 05 01:09 AM
if test using true/false or yes/no toolman Excel Discussion (Misc queries) 1 October 8th 05 05:54 AM
Displaying data based on a TRUE/FALSE value in a cell static69 Excel Discussion (Misc queries) 3 June 1st 05 07:09 AM
Want to change the color of a true/false logical statement with i. gregspainting Excel Worksheet Functions 2 February 19th 05 06:42 PM
replacing TRUE/FALSE Rogueuk New Users to Excel 0 February 9th 05 11:45 AM


All times are GMT +1. The time now is 05:38 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"