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

Mi Mix 3 5G UK Release Date, Price & Specification

The true inspiration behind Mr. Mime in Detective Pikachu - and why it's so hard to keep Pokémon…

WWDC 2019 dates and what to expect

Les meilleurs ordinateurs portables (2019)