Welcome Guest
Log In | Register )
You last visited December 2, 2016, 5:18 pm
All times shown are
Eastern Time (GMT-5:00)

help with excel formula pls...

Topic closed. 4 replies. Last post 7 years ago by Raven62.

Page 1 of 1
PrintE-mailLink
Avatar

Philippines
Member #67927
December 8, 2008
67 Posts
Offline
Posted: June 11, 2009, 12:13 pm - IP Logged

good day sir/mam. :)

can someone please help me with an excel formula? for example i have 3 rows and each has a number

ex. 10 20 30

and i want to find out what is the lowest and highest number for the 3 rows and i wanted to put it in another two rows 1 for the lowest and 1 for the higest. is it possible to do this? tnx alot to anyone who will kindly reply.

ex again

row A1, A2, A3 has different numbers and i want to find out what is the lowest and higest number of the three and i want to put the lowest number in A5 and the higest number in A6. tnx again to anyone who will kindly reply or even read my post. :)

    Avatar

    United States
    Member #33295
    February 19, 2006
    699 Posts
    Offline
    Posted: June 11, 2009, 12:22 pm - IP Logged

    In A5 use this formula   =MIN(A1:A3)
    In A6 use this formula   =MAX(A1:A3)

    Isabel, you are going to feel very silly when this turns out to be make-believe.

      Avatar

      Philippines
      Member #67927
      December 8, 2008
      67 Posts
      Offline
      Posted: June 11, 2009, 12:27 pm - IP Logged

      tnx alot sir. :) really appreciate it. :)

        Avatar

        United States
        Member #33295
        February 19, 2006
        699 Posts
        Offline
        Posted: June 11, 2009, 12:29 pm - IP Logged

        Thumbs Up

        Isabel, you are going to feel very silly when this turns out to be make-believe.

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          49614 Posts
          Online
          Posted: June 11, 2009, 5:40 pm - IP Logged

          In A5 use this formula: =SMALL(A1:A3,1)

          In A6 use this formula: =SMALL(A1:A3,3)

          A mind once stretched by a new idea never returns to its original dimensions!