Jan 31 2023 05:56 PM
Please guide me... why am i getting #NAME?
Jan 31 2023 06:54 PM
@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.
=IFS(B1>=90,"A",B1>=80,"B",B1>=70,"C",B1>=60,"D",B1<60,"F")
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.
Jan 31 2023 07:47 PM