How can I use the Find function to find the results of a formula in another cell?

[USAMax]

I have several cells that show Payment 1, Payment 2, Payment 3 and so on depending on values in another cell. If I manually change the cell all of the following cells will adjust to show that the current cell is not a payment.

Cell C13

=IF(ISBLANK(C9), "", addth(A13) & " Payment:")



I need another cell to see if the word, “Payment” is in the cell. If it is then it does one thing, else it will do something else.

=IF(C13=0, "",IF(ISERROR(FIND(B13, "Payment", 1)), C9, C9-C13))



How do I get the FIND command to see “Payment” within the results of the formula in C13 or “Payment” in in the formula cell C13.

 

[Fluff]

How about

=IF(C13=0, "",IF(ISERROR(FIND("Payment", C13)), C9, C9-C13))