Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lotus Notes 123 Nested If Then Statement

Status
Not open for further replies.

AbellM

Technical User
Jan 3, 2014
1
US
I wrote a nested @if statement for a co-worker and am completely unfamiliar with syntax. The formula is below:

Code:
@IF(E6>3/3/08; @IF(J6>=7;3; @IF(J6>=2&<7;2; @IF(J6>=1&<2;1;0))); @IF(J6>=25;5; @IF(J6>=16&<25;4; @IF(J6>=7&<16;3; @IF(J6>=2&<7;2; @IF(J6>=1&<2;1;0))))))

E6 is a specific Date and J6 is the number of years someone has worked at the company. The return value is to be an integer (0-5).

After placing this formula into the cell, it places the cursor before the second "2": @if(J6>=2&<7;2; etc).

Could someone lead me to the error and help resolve this formula?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top