IFS function
Summary
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
Syntax
IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
Example
=IFS(A2>89,"A",A2>79,"B",A2>69,"C",A2>59,"D",TRUE,"F")