CODEWITHSUNDEEP
excelexcel-formulavba
Alvin123
Alvin123

Reputation: 53

Why i add And condition in IF function doesn't work?

I have following table,I used {=MAX(IF(M21:M28=1,N21:N28))} to get max value according to the same No 1 and it gives the right value 99915.But if I want to add another condition, eg with same name=hao and same No=1. I should get 916. This is the one i used here but give me 0. Don't know why ?? Thanks

{=MAX(IF(AND(M21:M28=1,L21:L28="hao"),N21:N28))}

Name    No  Value
hao     1   10  
hao     1   11
rui     2   12 
rui     1   213
alvin   2   14
alvin   1   99915
hao     1   916
hao     3   9917

Upvotes: 0

Views: 65

Answers (1)

rwilson
rwilson

Reputation: 2145

Instead of using "AND", you can just use another IF statement:

{=MAX(IF(M21:M28=1,IF(L21:L28="hao",N21:N28)))}

Upvotes: 1

Related Questions