SOLVED

Need help in formula in calculated column with multiple IF statement

%3CLINGO-SUB%20id%3D%22lingo-sub-2363861%22%20slang%3D%22en-US%22%3ENeed%20help%20in%20formula%20in%20calculated%20column%20with%20multiple%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2363861%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20Please%20can%20anyone%20help%20me%20with%20this!%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20created%20a%20calculated%20column%202%20that%20based%20on%20another%20calculated%20column%201%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20calculated%20column%201%20as%207%2C%2025%2C%201%2C%205%2C%206%2C%203%2C%2010%2C%205.%20So%20I%20wanted%20to%20create%20a%20calculated%20column%202%20with%20the%20following%20conditions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%5Bcalculated%20column%201%5D%26gt%3B%3D7%2C%20returned%20as%20%22Low%22%2C%3C%2FP%3E%3CP%3EIF(AND(%5Bcalculated%20column%201%5D%26lt%3B%3D5%2C%5Bcalculated%20column%201%5D%26gt%3B%3D3%2C%20returned%20as%20%22Medium%22%2C%3C%2FP%3E%3CP%3EIF%5Bcalculated%20column%201%5D%26lt%3B%3D2%2C%20returned%20as%20%22Urgent%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFYI%2C%3C%2FP%3E%3CP%3EIf%20the%20calculated%20column%201%20has%20number%20greater%20or%20equal%20to%207%2C%20returned%20as%20%22Low%22%20in%20calculated%20column%202.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20calculated%20column%201%20has%20number%20less%20than%20or%20equal%20to%205%20and%20greater%20or%20equal%20to%203%2C%20returned%20as%20%22Medium%22%20in%20calculated%20column%202.%3C%2FP%3E%3CP%3EIf%20the%20calculated%20column%201%20has%20number%20less%20than%20or%20equal%20to%202%2C%20returned%20as%20%22Urgent%22%20in%20calculated%20column%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tested%20the%20calculated%20column%20with%20my%20formula%20(below)%2C%20it%20does%20not%20work%20and%20show%20as%20syntax%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(IF%5BPriority1%5D%26gt%3B%3D7%2C%22Low%22%2CIF(AND(%5BPriority1%5D%26lt%3B%3D5%2C%5BPriority1%5D%26gt%3B%3D3%2C%22Medium%22))%2CIF%5BPriority1%5D%26lt%3B%3D2%2C%22Urgent%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20anyone%20fix%20this%20for%20me%3F%20Many%20Thanks!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E**%20Sorry%20if%20its%20too%20long%20to%20read%2C%20i%20just%20need%20to%20make%20sure%20it%20is%20clear**%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2363861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Columns%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Formula%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2367403%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20in%20formula%20in%20calculated%20column%20with%20multiple%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056699%22%20target%3D%22_blank%22%3E%40Celinay%3C%2FA%3E%26nbsp%3B%3DIF(Priority1%26gt%3B%3D7%2C%22Low%22%2CIF(AND(Priority1%26gt%3B%3D3%2CPriority1%26lt%3B%3D6)%2C%22Medium%22%2C%22Urgent%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%2C%20Website%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!!!

 

2 Replies
best response confirmed by Celinay (New Contributor)
Solution

@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)