large div#0

[mc-iii]

Example:

Column a Column B Column C
Paris 100 5
London 200 3
NY 50 0


{Large(B1:b3/c1:c3,1)}

Because c3 is 0, the don´t works the formula. I don´t want to d
another column with c/b.

thanks

m

 

[JE McGimpsey]

One way (array-entered:CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(C1:C3=0,"",B1:B3/C1:C3))

 

[Frank Kabel]

Hi
try the array formula
=LARGE(IF(C1:C3<>0,B1:B3/C1:C3),1)

or
=MAX(IF(C1:C3<>0,B1:B3/C1:C3))

 

[mc-iii]

Thanks,


M