Formula Problem

[mjones]

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")),"Warning","")}

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

 

[Claus Busch]

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

 

[joeu2004]

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/Forums/en-US/category/officeexcel.