i need help with a function application with multiple arguments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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"
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple logic tests 0
hOW TO USE eXCEL FUNCTION 2
return different values based on 4 criteria? 4
Excel Need Countifs Formula Help 0
Carrying out calculations on segments of data from within a workbo 1
SUM, IF, OR, AND array 4
how do I get a result if one cell is X and the 2nd cell is Y where 5
SUM, IF, AND, OR array 1

Back
Top