SEANSKIM15Copper ContributorFeb 01, 2023simple IFS formula. what am i doing wrong here? Please guide me... why am i getting #NAME? Show More
JoeUser2004Bronze ContributorFeb 01, 2023SEANSKIM15 In lieu of IFS, try: =LOOKUP(B1, {0, 60, 70, 80, 90}, {"F", "D", "C", "B", "A"} )
