Formula Syntax - What it means?

Q

QTE

Hi Excel Forum,

I believe the following formulas all find the MINIMUM value that is NOT
= zero (<>0) and produce the same results. I am unsure of their syntax.
Can you explain the syntax of the following formulas and the
differences between them:

=MIN(IF(A1:A20,A1:A20))

=MIN(IF(A1:A20<>0,A1:A20))

=MIN(IF(A1:A20<>0,A1:A20,""))

How does the first formula work and, if there is a zero 0 avoid
returning a zero 0 without mentioning NOT = zero <>0?

what are the quotation marks for and what do they do?

When would it be preferable to use one syntax rather than another?

What signifies or denotes an array formula?

Your assistance is appreciated.

Kind regards,
QTE
 

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

Formula Syntax - What it means? 2
Formula Syntax - What it means? 2
Minimum array formula. 5
Formual Syntax? 3
SUM every other row in a column 4
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
MINIMUM OF POSITIVE VALUES only 4
another EXPERT LEVEL FORMULA from me 2

Top