I am trying to create the below excel formula on a access table and it is not working. Any suggestions, thanks.
Excel formula - =IF(ISBLANK(G2),F2,IF(G2="UNKNW",F2,G2))
<tbody>
</tbody>
Access table formula - IsNull( [PAYOR_CD] , [BILL_CD] , IF( [PAYOR_CD] ="UNKNW", [BILL_CD], [PAYOR_CD] ))
<tbody>
</tbody>
Excel formula - =IF(ISBLANK(G2),F2,IF(G2="UNKNW",F2,G2))
C | D | E | F | G | |
1 | Year | Acct | Comp Code | BILL_CD | PAYOR_CD |
2 | 2014 | 0000000 | CM | MH34 | UNKNW |
<tbody>
</tbody>
Access table formula - IsNull( [PAYOR_CD] , [BILL_CD] , IF( [PAYOR_CD] ="UNKNW", [BILL_CD], [PAYOR_CD] ))
Year | Acct | Comp Code | BILL_CD | PAYOR_CD |
<tbody>
</tbody>