IF Statement Question

Options

I am trying to get a formula to multiply [Sale Amount] by 12 if ERP is not JD Edwards, Microsoft AX, or Microsoft D365 OnPrem; otherwise, leave it blank...

I have tried the following formulas (with their corresponding error messages).

Is there an alternate formula I can use?

1)

=IF(OR(ISINSET([ERP]@row, "JD Edwards", "Microsoft AX", "Microsoft D365 OnPrem")), "", [Sale Amount]@row * 12) -> #UNPARSEABLE


2)

=IFERROR(IF(([Sale Amount]@row * 12), ERP@row, <>"JD Edwards", ERP@row, <>"Microsoft AX", ERP@row, <>"Microsoft D365 OnPrem"), "") -> #INCORRECT ARGUMENT

Answers

  • JamesB
    JamesB ✭✭✭✭✭✭
    Options

    @amy.cooper This should work for you. IF ERP is one of the 3 variables, then blank. If it is not one of the three then take the Sales Amount *12.

    =IF(OR(ERP@row = "JD Edwards", ERP@row = "Microsoft AX", ERP@row = "Microsoft D365 OnPrem"), "", [Sale Amount]@row * 12)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!