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.
Solved! Go to Solution.
Thanks