Matching a percentage dropdown entry

egrigson

I've got a pretty simple requirement which I'm struggling with. I have a dropdown defined with % values for completion (ie 100%, 75%, 50% etc) and I want to create a formula which searches for completed tasks (ie any cell with 100%). I imagine this is pretty common.

However, the cell type doesn't seem to be textual, nor does it seem to behave as a normal number. If I use a simple ISNUMBER() function for the cell in question it returns TRUE, but if I then try to do an =IF(Status1=100%, "Complete","Incomplete") I get 'Incomplete' even when the value is 100%. Likewise other numerical comparison operators such as > don't seem to recognise it as a number.

I can't find any functions to convert a number to text, and as it's a number type the usual FIND function doesn't work.

Any ideas? 

Andrée Starå

Hi,

It's because you cant check percentage in the formula. It has to be input as numbers. 1=100%, 0,75=75% and so on.

=IF([%]@row = 1; "Complete"; "Incomplete")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

egrigson

That does the job, thanks very much for the speedy response!

Ed

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée