I need a formula that will read 2 possibilities in 2 different cells and output 1 of 3 possible outcomes in a third. So if the first column can be 'new' or 'used' and the second column can be 'yes' or 'no' the third column needs to have; a value of 10 IF 'new' and 'yes', 20 if 'used' and 'yes' and return a value of 0 if the second column is a 'no' regardless of the first. Can anyone help please!
Aucun commentaire:
Enregistrer un commentaire