Thread: Get MAX value according to TRUE/FALSE flag
View Single Post
  #3   Report Post  
Tetsuya Oguma
 
Posts: n/a
Default
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?
Reply With QuoteReply With Quote