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