locked
IF Statement not working RRS feed

  • Question

  • I moved a table from Access 2016 to a SharePoint list and I am getting errors in a calculation now in SharePoint.

    Access Calculation: IIf([Amount]=0,0,IIf([Reimburse]=-1,0,([Amount]*0.029)+0.3))

    SharePoint created: =IF(NZ(Amount=0,FALSE),0,IF(NZ(Reimburse=-1,FALSE),0,(Amount*0.029)+0.3))

    The SharePoint list displays: #VALUE! in all fields except when Amount is 0, then it displays 0.00


    John Fletcher

    Wednesday, September 7, 2016 8:16 PM

All replies