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?
|