Forum Discussion

Rinda-81's avatar
Rinda-81
New Member
7 years ago
Solved

If Or Statement

I'm trying to write a formulat that says  IF (WAM[bg16.srvc_ctrt]="030111","TOP") OR  IF (WAM[bg16.srvc_ctrt]="030111","LOW")   Bascially if contract is 030111 call it TOP or LOW.   Please help...
  • parry2k's avatar
    7 years ago

    Rinda-81 try this

     

    TopOrLow = IF(yourtable[yourcolumn] = "030111", "TOP", "LOW")