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

Huawei Mate 30 Pro Review: Hands-on

Fred Deakin on creating the artwork for his sci-fi rock opera The Lasters

Best iOS 13 features: What does iOS 13 do

Les meilleures enceintes connectées avec écran tactile (2019)