🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

If with right nested

User: "Jon_21381"
Jon_21381
Altair Community Member
Updated by Jon_21381
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

------------------------------

Find more posts tagged with

English
Monarch
Sort by:
1 - 2 of 21
    User: "Al_22614"
    Al_22614
    Altair Community Member
    Updated by Al_22614
    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

    ------------------------------
    "
    User: "Al_22614"
    Al_22614
    Altair Community Member
    Updated by Al_22614

    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

    ------------------------------
    "
Quick Links