simple IFS formula. what am i doing wrong here?

Copper Contributor


Please guide me... why am i getting #NAME?

2 Replies

@SEANSKIM15 Your formula look correct. What is your excel version? Do you have access to IFS() function on your version of excel? Below formula give me correct result.


Based on regional and language settings, you may need to use semicolon (;) rather than comma (,). You B column data may stored as text. Otherwise your formula structure is correct.



In lieu of IFS, try:


=LOOKUP(B1, {0, 60, 70, 80, 90}, {"F", "D", "C", "B", "A"} )