🎉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

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

Accepted answers

All comments

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

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

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

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