# Nested IF and percents

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

• ✭✭✭
Options

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

IPC

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

• ✭✭✭
Options

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

It works. thanks a lot.

IPC

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!