Conditional Column not quite correct

Hi mattb1990 

You can refer to the following example:

Create a custom column in power query

if [Number of Runners] >= 5 and [Number of Runners] < 10 then "Silver" else if [Number of Runners] >= 10 and [Number of Runners] < 20 then "Gold" else if [Number of Runners] >= 20 then "Platinum" else "Bronze"

 Output:

You need to put interval to the condition, such as [5,10] [10,20]

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.