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