Nested IF and percents

System

This discussion was created from comments split from: How to use multiple IF and AND functions for symbol formula.

IPC

Hello @Paul Newcome,

Can you help me with the syntax as well please?

=IF([% Complete 2023-Q1]@row =0, "Not Started"),

IF(AND([% Complete 2023-Q1]@row > 0 and <= 0.25, "Initial Progress"),

IF(AND([% Complete 2023-Q1]@row > .25 and <= 0.50, "Mid-way Progress"),

IF(AND([% Complete 2023-Q1]@row > .51 and <= 0.90 "Major Progress"),

IF([% Complete 2023-Q1]@row =1, "Completed")))))

Basically if progress is 0 then not stargted

1-25% = Initial progress

26-50-mid-way progress

51-90 Major progress

Above formula results to unparseable

Thanks in advance.

IPC

Nick Korna

Hi @IPC,

This formula should do what you're after:

=IF([% Complete 2023-Q1]@row = 0, "Not Started", IF([% Complete 2023-Q1]@row <= 0.25, "Initial Progress", IF([% Complete 2023-Q1]@row <= 0.5, "Mid-way progress", IF([% Complete 2023-Q1]@row <= 0.9, "Major Progress", IF([% Complete 2023-Q1]@row = 1, "Completed")))))

Output:

There is small gap where nothing is returned between 90 and 100%, but other than that it fulfils your requirements.

If you've any additional questions or comments then just post! 😊

Paul Newcome

What about 91% - 99%?

IPC

Thanks @Nick Korna. The missing part is "under approval".

It works. thanks a lot.

IPC