i need help with a function application with multiple arguments
 

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

i need help with a function application with multiple arguments
 

"tarabull" wrote:

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"

i need help with a function application with multiple arguments
 

On Fri, 2 Nov 2007 20:08:00 -0700, tarabull
wrote:

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

i need help with a function application with multiple arguments
 

One way:

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

In article ,
tarabull wrote:

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