Using IF in Excel Spreadsheet

  belayer 19:10 10 Apr 2017
Locked

I am sure this is obvious to folks out there!

I have a short list on numbers in a list of cells (e.g. - c3: c14) and I want the spreadsheet to select the lowest value entry and display it in another cell.

Do I use an 'IF' formula? How

  belayer 19:36 10 Apr 2017

I have solved this thanks using the =MIN(a3:a14) formula.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)