If-Then statement with multiple conditions

M

Merlin

I need help with the following statement:
=+IF(and(G8<H8<I8,"Bidder 1"),IF(and(H8<G8<I8,"Bidder 2"),"Bidder 3"))

I am wanting the cell to produce the name of the lowest bidder
G8=Bidder 1 value ($300)
H8=Bidder 2 value ($600)
I8= Bidder 3 value ($100)
 
C

Caeres

I'm thinking this is what you want:

=IF(AND(G8<H8, H8<I8), "Bidder 1", IF(AND(H8<G8, G8<I8), "Bidder 2", "Bidder
3"))

Looks like you just had your parentheses mixed up, plus I don't think Excel
will let you use the x<y<z notation like you want (it'll evaluate x<y first,
and return either true (=1) or false (=0), and then compare the numeric form
of either true or false with z).
 

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

conditional data transfer from multiple sheets 0
How do I combine/join multiple formulas 2
Multiple If Stmts 2
Need help with a formula 3
Help With A Spreadsheet for a silent auction 1
IF FUNCTION, ADD MULTIPLE NUMBERS 2
help reducing this long nested functuion? 3
new user needs help 8

Top