or with blanks and once again (sadly) array entered

=MAX(IF(ISNUMBER(A1:A100/B1:B100),A1:A100/(A1:A100+B1:B100),FALSE))

Mike

"adimar" wrote:

I have numbers in columns A1:A100 and B1:B100.
I need the result for MAX(Ai / (Ai + Bi)).
Is there a way to write a worksheet formula and avoid populating an
intermediate column for Ai + Bi?
Also, I'm trying to avoid writing a macro.


Thank you.