0

formula using more then 1 ”IF”

Home › Forums › Discussion Forum › formula using more then 1 ”IF”

Tagged: 

Viewing 3 reply threads
  • Author
    Posts
    • 11/08/2021 at 9:09 am #496282
      guy forget
      Participant

      I need to write a formula using more than one ‘’IF’’. How can I do it?
      Here is my first ‘’IF’’
      IIf([Noms ressources]=”LAS Manager (QC)”;[Coût2];0) (this on works)
      I would like to add some more like:
      IIf([Noms ressources]=”LAS Manager (ON)”;[Coût2];0)
      IIf([Noms ressources]=”LAS Manager (WES)”;[Coût2];0)
      Etc..

    • 01/27/2022 at 3:08 am #504739
      Anonymous
      Inactive

      I also want to know how can I do it. I have tried to search it online on google search but can’t find it anywhere.

    • 01/29/2022 at 4:18 pm #505046
      Ismet Kocaman
      Guest

      You can nest the iif expressions for this purpose. But I would rather use the switch function since all expressions have “0” in the false part. See below:
      switch([Text1]=”LAS Manager (QC)”,[Text2],[Text1]=”LAS Manager (ON)”,[Text3],[Text1]=”LAS Manager (WES)”,”Information”,True,”Default Information”)

      Just replace “Default Information” with “0” or some other information. You can enter this formula to a text field such as Text4. Text1 contains the search text, and the others are obvious.

      The Switch functions is described here at: https://support.microsoft.com/en-us/office/project-functions-for-custom-fields-in-project-desktop-7e525143-380f-4083-8d5a-3ecc6ba44f22
      This support article explains how to use the immediate if function (iif) and how to create nested iifs: https://support.microsoft.com/en-us/office/iif-function-32436ecf-c629-48a3-9900-647539c764e3

    • 01/29/2022 at 4:21 pm #505047
      Ismet Kocaman
      Guest

      You can nest the iif expressions for this purpose. But I would rather use the switch function since all expressions have “0” in the false part. See below:
      switch([Text1]=”LAS Manager (QC)”,[Text2],[Text1]=”LAS Manager (ON)”,[Text3],[Text1]=”LAS Manager (WES)”,”Information”,True,”Default Information”)

      Just replace “Default Information” with “0” or some other information. You can enter this formula to a text field such as Text4. Text1 contains the search text, and the others are obvious.

      The Switch function is described here at: https://support.microsoft.com/en-us/office/project-functions-for-custom-fields-in-project-desktop-7e525143-380f-4083-8d5a-3ecc6ba44f22
      This support article explains how to use the immediate if function (iif) and how to create nested iifs: https://support.microsoft.com/en-us/office/iif-function-32436ecf-c629-48a3-9900-647539c764e3

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.