Discussions

Expand all | Collapse all

Help with IF formula

  • 1.  Help with IF formula

    Posted 03-08-2018 15:15
    I need help with an If formula. I'm trying to say: If the "type of record" field contains the word "actual", add cost and qty fields together. Otherwise leave blank.


  • 2.  RE: Help with IF formula

    Posted 03-08-2018 15:19
    IF(Contains([type of record], "actual"), [cost] + [qty])


  • 3.  RE: Help with IF formula

    Posted 03-08-2018 15:22

    Thank you so much! :)