Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Hi All,
I noticed a formula isn't working. Does anyone know how to correct it? Formula is {=IF(AND(COUNTIF(ANeedToFinalizeColumn,"<Collect payment/ update payment method")=0,COUNTIF(AmountDueToQCPColumn,"<0")),"W arning","")} Where ANeedToFinalizeColumn is named as =TRANSACTIONS!$AD$7:$AH$138 Where AmountDueToQCPColumn is named as =TRANSACTIONS!$K$7:$K$138 If one of the five "A Need To Finalize Columns" does not have "Collect payment/update payment method" and there is a number in the "Amount Due To QCP Column", return "Warning" so we don't forget to collect the payment. Thank you for reading my post, Michele |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Hi Michelle,
Am Sat, 30 Jul 2011 07:31:26 -0700 (PDT) schrieb mjones: If one of the five "A Need To Finalize Columns" does not have "Collect payment/update payment method" and there is a number in the "Amount Due To QCP Column", return "Warning" so we don't forget to collect the payment. I would do it with conditional formatting. Select K7:AH138 = Format = Coditional Formatting = Formula: =AND(ISNUMBER($K7),COUNTIF($AD7:$AH7,"Collect payment/update payment method")<5) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
"mjones" wrote:
Where ANeedToFinalizeColumn is named as =TRANSACTIONS!$AD$7:$AH$138 Where AmountDueToQCPColumn is named as =TRANSACTIONS!$K$7:$K$138 If one of the five "A Need To Finalize Columns" does not have "Collect payment/update payment method" and there is a number in the "Amount Due To QCP Column", return "Warning" so we don't forget to collect the payment. Please see the discussion in the Microsoft Answers Forum. For those who want to follow along, PS: go to http://social.answers.microsoft.com/...ry/officeexcel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem? | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem. | Excel Worksheet Functions | |||
Problem Formula | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |