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

Google Home Hub review

Print legends Dan Mumford and Supermundane on making the leap from 2D to AR

How to watch Apple’s October 2018 iPad launch

OnePlus 6T : date de sortie, prix et autres rumeurs