View Single Post
  #4   Report Post  
KL
 
Posts: n/a
Default

sorry, because the second formula I gave you IS an ARRAY formula
(Ctrl+Shift+Enter)

Regards,
KL

"Tetsuya Oguma" wrote in message
...
Your formula works for me and it doesn't need to be array-entered.
Another
way could be: =MAX(A1:C1*A2:C2)

If the first flag (A1) is FALSE the formula gives me zero (0)... Why?