ExcelBanter - RETREIVING THE SMALLEST NUMBER

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - RETREIVING THE SMALLEST NUMBER (https://www.excelbanter.com/excel-worksheet-functions/101943-retreiving-smallest-number.html)

ashaback

RETREIVING THE SMALLEST NUMBER

I have 3 columns of numbers, How in my 4th column can I have it retrieve the
smallest number of the 3 columns?

Thanks a bunch.

Ron Coderre

RETREIVING THE SMALLEST NUMBER

Try something like this:

For values in A1:C1

D1: =MIN(A1:C1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"ashaback" wrote:

I have 3 columns of numbers, How in my 4th column can I have it retrieve the
smallest number of the 3 columns?

Thanks a bunch.

All times are GMT +1. The time now is 12:00 AM.