Forum Discussion
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...
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)
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)
- Thank you! RobElliott It works!
