mercredi 2 décembre 2015

Nested IF statements with AND in excel

I have a column (C) in Excel that looks like this: columns

I want the bottom cell (currently green and displaying 1) to: display 2 if sum of c2:c14 = 13 and c16 = 1 display 1 if sum of c2:c14 >= 7 and c16 = 1 else display 0

This is what I have and it is saying it is an invalid formula, which I am sure it is, I just can't work out where I have gone wrong...

=IF(AND(SUM(C2:C14=13,C16=1),2)),IF(AND(SUM(C2:C14)>=7,C16=1,1),0)

Anyone able to help?!

Aucun commentaire:

Enregistrer un commentaire