Forum Discussion

SEANSKIM15's avatar
SEANSKIM15
Copper Contributor
Feb 01, 2023

simple IFS formula. what am i doing wrong here?

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

2 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    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.

Resources