if or function; please help

[hdayanan]

I am new to excel so please bear with me.

I have colomn a1:a8 with numbers
A
1 5
2 4
3 7
4 3
5 2
6 0
7 1
8 0


In B1 thru B8 I want to get the minimum of A1:A8 other than zero but
if corresponding row on A is zero return zero,

for ex: B1:B5 and B7 would return a value of 1 and B6 and B8 would
return 0

somebody please help me with a macro.

Kind Regards
Dan

 

[Guest]

try =IF(B1=0,0,1)

 

[Guest]

really simple thing - if you dont need the 0's blank them
then use the formual min(range)

 

[Guest]

whoops - shoudl have said if you dont need the 0's delete
the 0's then use the formula in col b like =IF(a1="",0,MIN
($a$1:$a$8)) and copy it down it shoudl do the trick
Gary
OZ

 

[Patti]

Will this work?

In B1 enter:

=IF(A2=0,0,MIN(IF($A$2:$A$9>0,$A$2:$A$9))) and enter with
CTRL SHIFT ENTER (an array formula)

 

[hdayanan]

patti and anonymous,

Both the formulas worked, I greatly appreciate your help and time.

Kind Regards
Da