locked
Calculated column syntax error RRS feed

  • Question

  • Hi everyone,

    I'm attempting to fill in a formula for a calculated column.

    =IF(AND([Exec], Status<>Completed, Status<>Cancelled), Title, "")

    Essentially, I need a formula that says "If Exec is equal to yes and Status does not equal completed and status does not equal canceled, if true return Title, if false return "".

    Any ideas?

    Thanks for any assistance you can provide,

    Karen

    Tuesday, May 1, 2012 9:32 PM

Answers

  • Hi Karen,

    Please use the below syntax , I hope this will help you out with the above mentioned requirement.

    =IF(AND(Exec,Status<>"Completed",Status<>"Cancelled"),Title,"")

    Regards,

    Sachwani

    • Marked as answer by kb0722 Wednesday, May 2, 2012 9:54 PM
    Wednesday, May 2, 2012 2:28 AM

All replies

  • Hi Karen,

    Please use the below syntax , I hope this will help you out with the above mentioned requirement.

    =IF(AND(Exec,Status<>"Completed",Status<>"Cancelled"),Title,"")

    Regards,

    Sachwani

    • Marked as answer by kb0722 Wednesday, May 2, 2012 9:54 PM
    Wednesday, May 2, 2012 2:28 AM
  • Worked like a charm!
    Wednesday, May 2, 2012 9:54 PM