Formula Problem

  • Thread starter Thread starter mjones
  • Start date Start date
M

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
 
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.
Click to expand...

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
 
mjones said:
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.
Click to expand...

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.
 
Back
Top