Forum Discussion

Celinay's avatar
Celinay
Copper Contributor
May 18, 2021
Solved

Need help in formula in calculated column with multiple IF statement

Hi! Please can anyone help me with this! 😞

 

I am trying to created a calculated column 2 that based on another calculated column 1 .

 

I have calculated column 1 as 7, 25, 1, 5, 6, 3, 10, 5. So I wanted to create a calculated column 2 with the following conditions:

 

IF[calculated column 1]>=7, returned as "Low",

IF(AND([calculated column 1]<=5,[calculated column 1]>=3, returned as "Medium",

IF[calculated column 1]<=2, returned as "Urgent".

 

FYI,

If the calculated column 1 has number greater or equal to 7, returned as "Low" in calculated column 2. 

If the calculated column 1 has number less than or equal to 5 and greater or equal to 3, returned as "Medium" in calculated column 2.

If the calculated column 1 has number less than or equal to 2, returned as "Urgent" in calculated column 2.

 

I have tested the calculated column with my formula (below), it does not work and show as syntax error. 

=IF(IF[Priority1]>=7,"Low",IF(AND([Priority1]<=5,[Priority1]>=3,"Medium")),IF[Priority1]<=2,"Urgent")

 

Please can anyone fix this for me? Many Thanks!!

 

** Sorry if its too long to read, i just need to make sure it is clear**

 

Thank you!!!

 

  • Celinay =IF(Priority1>=7,"Low",IF(AND(Priority1>=3,Priority1<=6),"Medium","Urgent"))

     

    Rob
    Los Gallardos
    Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    Celinay =IF(Priority1>=7,"Low",IF(AND(Priority1>=3,Priority1<=6),"Medium","Urgent"))

     

    Rob
    Los Gallardos
    Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources