Thread
:
If-Then statement with multiple conditions
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett