i need help with a function application with multiple arguments

[tarabull]

if a is less than 4500 then b, if a is greater than or equal to 4500 but less
than 7500 then c, if a is greater or equal to 7500 then c

 

[tarabull]

if a is less than 4500 then b, if a is greater than or equal to 4500 but less
than 7500 then c, if a is greater or equal to 7500 then c

on the last "c" i meant "d"

 

[Ron Rosenfeld]

if a is less than 4500 then b, if a is greater than or equal to 4500 but less
than 7500 then c, if a is greater or equal to 7500 then c

With "a" in A1:

=VLOOKUP(A1,{-9.9999E+307,"b";4500,"c";7500,"d"},2)


--ron

 

[JE McGimpsey]

One way:

=IF(a<4500,b,IF(a<7500,c,d))