Tag Info

Hot answers tagged

1

You can use a formula like this in column B =IF(A1>=PERCENTILE($A$1:$A$10,0.4),1,0) Depending on your specific data, you may need >= or just > - you can determine that when working with the data.



Only top voted, non community-wiki answers of a minimum length are eligible