Help with MIN fxn please!

J

jentalkin2u

Hello. I'm working on an Excel case in my MBA program. I have to use the
MIN function fo find the minimum number in a column of dollar amounts.
Problem is - there are a few zero values and my instructor wants the zeros to
be ignored. In other words, I have to use the MIN fxn in combinatio with
another fxn to ignore the zeros so that $0.00 won't be returned as the
minimum value. I have no clue how to ignore the zeros. Can anyone help?
Thanks!
 
J

jentalkin2u

Nevermind - I did a search on this forum and found my answer. Someone else
had asked the same question a couple of months ago. Thanks anyway!
 

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

Mail Merge Switch - Dollars to Words 0
MIN ARRAY FORMULA 13
MAX / MIN function problem 4
In part of a col of data, I need the minimum number, but exclude z 10
Pick the low number in a column of Numbers 3
Min function with an offset 1
ignore MAX and MIN values in a set to calculate average 5
Pass The Formulas Please 3

Top