lundi 15 janvier 2018

Excel "IF" Statements Across Multiple Colums

I am trying to make a IF Statement with a (80%) or .80 threshold to check across 5 columns.

1            2           3           4          5

0.821282128 0.118611861 0.02990299  0.0070007   0.02320232

I tried using this:

=IF(E130>0.8, "A", IF(F130>0.8, "B", IF(G130>0.8, "C", IF(H130>0.8, "D", IF(I130>0.8, "E")))))

=IF(AND(E30>0.8),"A",IF(AND(F30>0.8),"B",IF(AND(G30>0.8),"C",IF(AND(H30>0.8),"D",IF(AND(I30>0.8),"E","NA")))))

Having trouble to getting this statement to work.

Aucun commentaire:

Enregistrer un commentaire