+ Reply to Thread
Results 1 to 3 of 3

Less than great

  1. #1
    Registered User
    Join Date
    04-11-2005
    Posts
    2

    Smile Less than great

    okay im kind of a noob but thats why im here so that you can all help me become a pro like you guys. anyway my question is this:
    i want to get the least number of 3 cells.
    ig. A1=1 B1=2 C1=3, now i want D1 to be equal to the smallest number (which is A1=1)

    and after that i want it be done to all cell numbers.
    ig. A1=x B1=x C1=x, D1 = the smallest between a1b1c1
    A2=x B2=x C2=x, D2 = the smallest between a2,b2,c2
    and so on until lets say D16

    can anyone tell me the formula i put i the D? and how to make it go on and on? Thanls a bunch

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Try...

    D1, copied down:

    =MIN(A1:C1)

    Hope this helps!

  3. #3
    Registered User
    Join Date
    04-11-2005
    Posts
    2
    You got it. thanks a bunch!

+ Reply to Thread

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