minimum function but want to exclude zero

G

Guest

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

Minimum non-zero value 3
In part of a col of data, I need the minimum number, but exclude z 10
finding minimum value excluding zero 6
Minimum Calculation 5
minimum function 3
Finding the MIN value, but greater than zero 2
Excel (non zero min value) 3
MINIMUM SEARCH IN THE NEXT 15 ENTRIES 1

Top