Results 1 to 2 of 2

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

Threaded View

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Sherman Oaks, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

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

    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!
    Attached Files Attached Files
    Last edited by williamfrus; 09-07-2012 at 06:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1