1 Reply Latest reply on Apr 24, 2011 4:29 AM by LaRetta_1

    Another question about Case function......

    leonhart1981

      Title

      Another question about Case function......

      Post

      I have understood the basic about Case function.

      However, I still have another question.

      Available field: Balance, Invoice, and Vender#1

      Here is the calculation that I wanna do:

      When Invoice contains a letter U and Vender#1 = ABC, then Balance = 0

      I have no clue how to write a formula with "contains"????