Thread: Convert Excel Formula To Access Thanks: 0 Likes: 0

1. Convert Excel Formula To Access

I am trying to convert an excel formula in access but don't have the knowledge to do so. Is there a way to convert this excel formula to run with my access query? This is what I am using in Excel. =IF(S2<1825,"< 5 Years Old",IF(AND(S2>1824),"> 5 Tears Old")). The Access database name is Raw_NJUNS and Column "S" is NTG Interval. I tried several things but, keep getting errors. Any help would be appreciated. Thanks.  Reply With Quote

2. Re: Convert Excel Formula To Access

I got it to work by using this formula in case anyone needs this in the future

<>5YRS_OLD: IIf([NTG INTERVAL]<=1825,"< 5yrs",IIf([NTG INTERVAL]>1825,"> 5yrs"  Reply With Quote

3. Re: Convert Excel Formula To Access

I guess you could also try:
<>5YRS_OLD: IIf([NTG INTERVAL]<=1825,"< 5yrs","> 5yrs")  Reply With Quote

4. Re: Convert Excel Formula To Access

Thanks. Ill give it a try  Reply With Quote

5. Re: Convert Excel Formula To Access

Similar with your Excel formula the second IF and the AND function are not required. If can return one value if true and another if false. IF,Then,Else.

Code:
=IF(S2>1825,">","<")&" 5 Years Old"  Reply With Quote

6. Re: Convert Excel Formula To Access

Similar with your Excel formula the second IF and the AND function are not required. If can return one value if true and another if false. IF,Then,Else.
Note that Access does NOT have an "IF" function. It has an "IIF" function.
Access VBA has a IF...THEN function that works similarly to Excel's VBA equivalent.  Reply With Quote

User Tag List

Tags for this Thread

access, column, convert, excel, formula  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•