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

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

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.