IF / IFS Function with greater than / less than

[VJarvis]

Hello all,
Am new here, so forgive me if this query seems a bit basic. Can anyone help me write a formula for the following, I've been struggling for an hour and can't figure it out. I'd like to write an IF / IFS statement where 0-28 returns a value of 'B', 29-56 returns 'WT,' 57-84 returns 'E' and anything greater returns 'GD.' Any help greatly appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LOOKUP(A2,{0,29,57,85},{"B","WT","E","GD"})

 

[VJarvis]

Hi & welcome to MrExcel.
How about

=LOOKUP(A2,{0,29,57,85},{"B","WT","E","GD"})

Works perfectly. Thanks so much for your help!

 

[Fluff]

You're welcome & thanks for the feedback.