I wrote a nested @if statement for a co-worker and am completely unfamiliar with syntax. The formula is below:
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?
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?