Hi, I'm trying to transfer the formula below from excel into access. I've tried several different variations in access the last attempt is at the bottom. Am I using the AND function correctly? Thank you for your help.
Excel
=IF(AND(D2=0,H2="Y"),"Stop Sale",IF(AND(F2>=0,H2="Y"),"Cut-off",IF(AND(F2>0,H2<>"Y"),"Available",IF(AND(F2=0,H2<>"y"),"Sold Out"))))
Access
IF2: IIF(AND([Allot]=0,[SS]="Y"),"Stop Sale",IIF(AND(F2>=0,[SS]="Y"),"Cut-off",IIF(AND([Rem]>0,[SS]<>"Y"),"Available",IIF(AND([Rem]=0,[SS]<>"y"),"Sold Out"))))
Bookmarks