View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default If-Then statement with multiple conditions


Have a look in the help index for MIN
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Merlin" wrote in message
...
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)