i need help with a function application with multiple arguments

T

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
 
T

tarabull

tarabull said:
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
Click to expand...

on the last "c" i meant "d"
 
R

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
Click to expand...

With "a" in A1:

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


--ron
 
Top