IF Statement that compares multiple cells and gives me the lowest number

**williamfrus** · 09-07-2012, 06:23 PM

I have a document that I'd like to compare the costs of products at multiple stores. Whichever store has the cheapest cost I'd like for that store name to be populated in column D. I know how to do an IF statement comparing two options but how do I do it with more than 2? I have attached the spreadsheet and if you look at row 9 that has all of the prices for each vendor.

Thanks for any and all help!

**MrShorty** · 09-07-2012, 07:37 PM

I would probably not even use an IF() function. Especially for learning purposes, I like to spread things out over several cells. So in 1 cell, use the =MIN() to return the smallest value. Then the =MATCH() function can be used to locate where the MIN occurs inside the range. Then the INDEX() function can used with result of the MATCH() function to return the store corresponding to the minimum.

IF Statement that compares multiple cells and gives me the lowest number

LinkBack

Thread Tools

Rate This Thread

Display

IF Statement that compares multiple cells and gives me the lowest number

Re: IF Statement that compares multiple cells and gives me the lowest number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions