Hi,
I am after a very simple formula in order to streamline project updates.
I would like the following to happen...

1. When % complete is equal to 0%, then return a number...in this case 1
2. When % complete is greater than 50%, then return a number...in this case 2
3. When % complete is equal to 100%, then return a number...in this case 3

I already have the column created and the graphcal indicators set to various colors should 1, 2 or 3 flag up...

Thank you in advance
CJA