% in formula issue

MBurdman

Good morning,

I have a column which named "% Complete". The next column, I wrote:

=IF([% Complete]@row = 100, "Complete", "Not Complete")

That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's complete.

If I add the % symbol:

=IF([% Complete]@row = 100%, "Complete", "Not Complete") → unparseable

Thanks all

Protonsponge

Hello @MBurdman

I think the following formula will work for you - replacing 100 with 1 when your column is formatted as a percentage.

=IF([% Complete]@row = 1, "Complete", "Not Complete")

I hope that is helpful to you in someway,

Protonsponge

Protonsponge

Hello @MBurdman

I think the following formula will work for you - replacing 100 with 1 when your column is formatted as a percentage.

=IF([% Complete]@row = 1, "Complete", "Not Complete")

I hope that is helpful to you in someway,

Protonsponge

MBurdman

Yep! That worked. Thanks so much.