Formula to bring 3 different status depending on percentage

[eddyrcabrera79]

Could you please let me know how to create a formula to work with 3 Different Status? I attached a doc. It will be column D and E. The formula will have to be fixed in column E as when it is 0% it will not bring the right value

If percentage = 100% it will bring the status Completed
if percentage < 100% it will bring the status In Progress
if percentage = 0% it will bring the status Not Started

[Bo_Ry]

Please try

=IF(D2,IF(D2=1,"Complete","InProgress"),"Not Started")

or

=IF(D2=1,"Complete",IF(D2,"InProgress","Not Started"))

[Sam Capricci]

just adjust the formula you had to this... =IF(D2=100%,"Complete",IF(AND(D2>0%,D2<100%),"In Progress", IF(D2=0%,"Not Started")))
or shorter =IF(D2=100%,"Complete",IF(AND(D2>0%,D2<100%),"In Progress","Not Started"))