Formula tool - IF condition output mismatch

[Inactive User]

Hello,

I have applied IF condition from column B to F based on column A but my output isn't accurate.

below is the expected output

Stock Percentage >= 20% && <=39.99 THEN 1 ELSE 0
Stock Percentage >= 40% && <=59.99 THEN 1 ELSE 0
Stock Percentage >= 60% && <=79.99 THEN 1 ELSE 0
Stock Percentage >= 80% && <=99.98 THEN 1 ELSE 0
Stock Percentage >= 99.99% THEN 1 ELSE 0

Please find the attached table data and advise.

[Inactive User]

Thanks