If with right nested

Jon_21381
Jon_21381 Altair Community Member
edited September 2019 in Community Q&A
Hello 

Is there any way to get the function to work in data watch

=IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

Thanks

------------------------------
Jon Pernice

------------------------------
Tagged:

Answers

  • Al_22614
    Al_22614 Altair Community Member
    edited September 2019
    Remove the equal sign "=" in the first "IF" statement

    HTH

    Al

    ------------------------------
    Al Rice
    Owner - President- CEO
    Trends In Data, LLC
    West Bloomfield MI
    (248) 761-5238
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-09-2019 04:55 PM
    From: Jon Pernice
    Subject: If with right nested

    Hello

    Is there any way to get the function to work in data watch

    =IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------
    "
  • Al_22614
    Al_22614 Altair Community Member
    edited September 2019
    Al_22614 said:

    Remove the equal sign "=" in the first "IF" statement

    HTH

    Al

    ------------------------------
    Al Rice
    Owner - President- CEO
    Trends In Data, LLC
    West Bloomfield MI
    (248) 761-5238
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-09-2019 04:55 PM
    From: Jon Pernice
    Subject: If with right nested

    Hello

    Is there any way to get the function to work in data watch

    =IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------
    "

    ... also, this fieldtype  is Character, so the 0 in the second IF statement should be in quotes "0"
    HTH
    Al

    ------------------------------
    Al Rice
    Owner - President- CEO
    Trends In Data, LLC
    West Bloomfield MI
    (248) 761-5238
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-09-2019 10:54 PM
    From: Al Rice
    Subject: If with right nested

    Remove the equal sign "=" in the first "IF" statement

    HTH

    Al

    ------------------------------
    Al Rice
    Owner - President- CEO
    Trends In Data, LLC
    West Bloomfield MI
    (248) 761-5238
    ------------------------------

    Original Message:
    Sent: 09-09-2019 04:55 PM
    From: Jon Pernice
    Subject: If with right nested

    Hello

    Is there any way to get the function to work in data watch

    =IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------
    "

Categories