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

Amazon Prime Day 2018: Best Deals & Launches

Say aloha to the summertime vibes of artist Kim Sielbeck

The best Amazon Prime Day Apple deals 2018

Les meilleures séries Amazon Prime Video (2018)