Intermediate
Nested IF Excel Formula
Create an Excel formula to categorize data based on score ranges.
📝 Contenu du Prompt
Write an Excel formula for column B that looks at the numerical score in column A. If the score is above 90, return 'A'. If between 80 and 89, return 'B'. If between 70 and 79, return 'C'. For anything below 70, return 'Fail'.