lundi 11 septembre 2017

Excel advanced multiple conditions formula

I need to write an IF in Excel with multiple conditions.

Basically, I need excel to return me this:

IF CR2=>2 and CI2=>2 and CH2=>2 it should return 1

IF CR2=>2 and CI2=>2 and CH2=1 it should return 2;

IF CR2=>2 and CI2=1 and CH2=>2) it should return 2;

IF CR2=>2 and CI2=1 and CH2=>1 it should return 3;

IF CR2=1 and CI2=1 and CH2=1 it should return 4.

I've been trying to get this right but with no success and I think the problem is probably due to the fact that I don't know how I can right the False statements in this case.

Any help would be appreciated. Thank you!

Aucun commentaire:

Enregistrer un commentaire