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!
Thank you!!

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Rinda-81 try this

     

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