Welcome Guest
You last visited May 27, 2017, 9:34 am
All times shown are
Eastern Time (GMT-5:00)

# help with excel formula pls...

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

 Page 1 of 1

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. :)

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.

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

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

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

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

New Jersey
United States
Member #17843
June 28, 2005
58364 Posts
Offline
 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!

 Page 1 of 1