IFs

Jon_21381
Jon_21381 Altair Community Member
edited June 2020 in Community Q&A
Hello 

Is it possible to do IFs statement in prep studio with and.  

Thanks

------------------------------
Jon Pernice

------------------------------
Tagged:

Answers

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited June 2020
    @Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

    If you have the most current version it should be in the drop down menu under Column>New Formula Column.

    The statement in Monarch is written a little differently than in other software. It would look like this;

    IF([Price]> 0 .and. [Item]='CD', 1, 0)

    I will try and send some screenshots later or a video if that will help. 

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-04-2020 04:05 PM
    From: Jon Pernice
    Subject: IFs

    Hello

    Is it possible to do IFs statement in prep studio with and.

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------"
  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited June 2020
    Baba Majekodunmi_21731 said:

    @Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

    If you have the most current version it should be in the drop down menu under Column>New Formula Column.

    The statement in Monarch is written a little differently than in other software. It would look like this;

    IF([Price]> 0 .and. [Item]='CD', 1, 0)

    I will try and send some screenshots later or a video if that will help. 

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-04-2020 04:05 PM
    From: Jon Pernice
    Subject: IFs

    Hello

    Is it possible to do IFs statement in prep studio with and.

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------"

    Hi @Jon Pernice, here's a sample screenshot below. Let us know if you need more assistance.

    image



    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-05-2020 05:49 AM
    From: Baba Majekodunmi
    Subject: IFs

    @Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

    If you have the most current version it should be in the drop down menu under Column>New Formula Column.

    The statement in Monarch is written a little differently than in other software. It would look like this;

    IF([Price]> 0 .and. [Item]='CD', 1, 0)

    I will try and send some screenshots later or a video if that will help. 

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------

    Original Message:
    Sent: 06-04-2020 04:05 PM
    From: Jon Pernice
    Subject: IFs

    Hello

    Is it possible to do IFs statement in prep studio with and.

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------"
  • Rebecca_Cronin
    Rebecca_Cronin
    Altair Employee
    edited June 2020
    Hi Jon, 

    I wanted to also share with you links to Monarch Documentation: ------------------------------
    Rebecca Cronin
    Customer Success & Community Manager
    Bedford MA
    (978) 275-8203
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-04-2020 04:05 PM
    From: Jon Pernice
    Subject: IFs

    Hello

    Is it possible to do IFs statement in prep studio with and.

    Thanks

    ------------------------------
    Jon Pernice

    ------------------------------"

Categories