Minimum Number

N

nnmmss

My Range in sheet is A1:M1. I have different numbers in these cell
Positive , Negative, and Zero. I want to show the minium of number i
Range B1:M1 in A1 if that number is not zero.
i mean if these are my number 10,3,0,28,2.4 the minium of thes
range of number shows me 2.4 not zero.
how can i use formulan for this function.

Thank yo
 
N

Norman Harker

Hi "nnmmss"

A non-array way (assuming no neg. numbers in range):

=SMALL(A2:D2,COUNTIF(A2:D2,0)+1)

With negative numbers:

=SMALL(A2:D2,COUNTIF(A2:D2,"<=0")+1)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

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

Sum Function has small remainder 2
Show value from one cell in another cell if today falls between a date range 5
Divide by the minimum non-zero number in a range of cells 22
Finding the proper style field and the numbered paragraph value within the style 0
Need a proper guru! My head hurts ;( 1
Calculations with possible null value fields 1
Conditional formatting Icons 0
SUMIF with broken range 10

Top