View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Merlin Merlin is offline
external usenet poster
 
Posts: 8
Default If-Then statement with multiple conditions

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)