minimum function but want to exclude zero

K

kinsey

I have a quotation form I use which has several supplier values in a column.
I want to calculate the minimum value but because every supplier does not
always
give a quote their value will show zero. In short I want the minimum in the
column
but excluding zero. How do I express this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed: Minimum value based upon either/or criteria 3
Autonumber field in Excel that behaves the same as Access 0
Calculate the median value before a specified list 0
Help with MIN fxn please! 2
finding minimum value excluding zero 6
return a minimum value of 1, except when multiplied by an empty ce 7
Help! Minimum Excluding zeros across multiple sheets 5
Formula function for ignoring cells/results equal to 0 (zero) ? 2

Top