I have a nested IF that checks the values of different cells, and accordingly SUMS a combination of different ranges.
As in the example below, there are 2 conditions, is there a way to make sure it returns the value of the highest SUM product?
=IF(AND(AW7=1,(OR(AND(AO7>=1,AU7>=1)))),SUM(B7,LARGE(C7:R7,{1}),LARGE(S7:AB7,{1})),IF(OR(AND(AO7>=0,AU7>=3)),SUM(B7,LARGE(S7:AB7,{1,2,3}))))
Perhaps I could incorporate a MAX function at the beginning of my formula? Would that work?
Many thanks,
Shyam
As in the example below, there are 2 conditions, is there a way to make sure it returns the value of the highest SUM product?
=IF(AND(AW7=1,(OR(AND(AO7>=1,AU7>=1)))),SUM(B7,LARGE(C7:R7,{1}),LARGE(S7:AB7,{1})),IF(OR(AND(AO7>=0,AU7>=3)),SUM(B7,LARGE(S7:AB7,{1,2,3}))))
Perhaps I could incorporate a MAX function at the beginning of my formula? Would that work?
Many thanks,
Shyam